Regular Expressions 101

^start of line

Negative Lookahead(?!0+\.0+$)

0+the literal 0 (48₁₀ / 60₈ / 30₁₆) , repeated at least once

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

0+the literal 0 (48₁₀ / 60₈ / 30₁₆) , repeated at least once

$end of line

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

Non-Capturing Group(?:,\d{3})*

*repeats the group contents below any number of times:

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

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

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

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

$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+\.0+$)\d{1,3}(?:,\d{3})*\.\d{2}$

New

1,100.00
0.00
0.11
0.01
1.11
1.457
2345656.45
23,345,345.45