Integer format without comma

salvadormarchan · ‎06-16-2011

Hi All,
I created a field within a certain table having an integer data type. I tested the value and it automatically provides a comma after every 3 decimal places.

Question: How do I disable this? We don't want the comma. I tried looking at the wiki (and googled it) but no avail.

Thanks,
Dor
(Day 45)

salvadormarchan · ‎09-29-2011

I have overcome this dilemma weeks ago. I am now writing it to share with you...

What I did was created another field having Integer datatype along with the required field that should have no comma (chosen data type is String); In the form, I created a section called 'Admin Use' and created a client script that hides it from non-admin users. The Integer field is in this section. So, when I perform import, I populate both fields. One for Business Analyst's use and one for us (Admin). SO, I can sort records with an integer-behaviour and not a string-behaviour.

If there's another way of doing this, please let me know. Thanks.

View solution in original post

Hurleybird · ‎12-10-2020

This, for me, was the answer! Thanks.

richard_selby · ‎07-11-2013

Thanks Russell.
Exactly what I needed too.
format=none is very useful, and not in the official SN wiki.
But where is the part which says format=x,xxx,xxx as a global setting, I wonder.

lhai · ‎06-22-2016

Hi Everyone!

I am experiencing the same problem and I must say it really is a pain.

The thing is that I imported numeric values to a String field and weirdly enough, it was formatted with commas.

I have also added the format = none to the Attributes, but the commas were not removed.

Any ideas what is happening?

Cheers,

Alyssa

lcbell · ‎07-14-2017

the dictionary attribute format=none only works for a numeric field such as integer or glide-date. See Dictionary Attributes - ServiceNow Wiki

If you import numeric values to a String field you should have a transform field map script to remove the commas.

Robbie3 · ‎02-20-2020

I had the same issue. Select Format as the attribute and then enter none as the value! 😉