Regular Expressions 101

^start of line

Negative Lookahead(?!0\.00)

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

00the literal text 00

\d{1,3}a digit, repeated between 1 and 3 times

Group 1(,\d{3})*

*repeats the group contents below any number of times:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\d{3}a digit, repeated exactly 3 times

Group 2(\.\d\d)?

?repeats the group contents below at most once:

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\da digit

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

^(?!0\.00)\d{1,3}(,\d{3})*(\.\d\d)?$

New

100.00
1,000.00
100,000.00
1,000,000.00
00.7
0.00