removing commas in numbers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2015 02:59 AM
Morning all,
I am importing some data from an old system into ServiceNow, the reference number from the previous system will go into a custom field in ServiceNow. This is working however it is adding a comma so the number becomes 32,546 instead of 32546. How do I stop this happening?
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2015 03:32 AM
Steve if you go to the dictionary entry for the field and in the Attributes field enter format=none that should do it.
HTH
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-12-2016 11:09 AM
Thanks Angus, that should be the correct answer I believe.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2018 04:27 AM
I'm very much new to ServiceNow. Could you please assist me step-wise on how to get it done?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2015 03:34 AM
Hi Steve,
Are you using xls file import to import the data? In that case, you can change the column type to Number may be.
Or you can specify in the import table that this particular field is a number and not a string.
Hope that helps.
-Mandar
