Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
Tera Guru
Tera Guru

[deleted]