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

[deleted]