Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Regex Validation for variable field to use decimal and comma only

Benjamin14
Giga Contributor

Hello I'm trying to figure out what regex values must be used in order to validate a field to a value like this:
Ex.
100,000.00
50,000.00

1,000,000.00
I have a regex validation but it accepts numbers without decimal places. ^(?!0\.00)\d{1,3}(,\d{3})*(\.\d\d)?$

1 ACCEPTED SOLUTION

Benjamin14
Giga Contributor

UPDATE:
Solve it using this -> ^[0-9]{1,3}(,[0-9]{3})*\.[0-9]+$

View solution in original post

3 REPLIES 3

Benjamin14
Giga Contributor

UPDATE:
Solve it using this -> ^[0-9]{1,3}(,[0-9]{3})*\.[0-9]+$

Is this an example of what you text validation looks like now?

50,000.00

I tried your string and 50,000.00 comes up as "Not a Valid Currency"

phil_bool_unifi
Kilo Sage

[deleted]