regex101: PCRE (Legacy) Match Workspace

^start of line

Negative Lookahead(?!^(0{1,3}\.?)+(,00)?$)

^start of line

Group 1(0{1,3}\.?)+

+repeats the group contents below at least once:

0{1,3}the literal 0 (48₁₀ / 60₈ / 30₁₆) , repeated between 1 and 3 times

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

Group 2(,00)?

?repeats the group contents below at most once:

,00the literal text ,00

$end of line

Group 3(\d{1,3}\.?)+

+repeats the group contents below at least once:

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

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

Group 4(,\d\d?)?

?repeats the group contents below at most once:

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

\da digit

\d?optionally matches a digit

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

Search reference

Regular Expression

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

Test String
New

0,00
00,00
000,00
0.000,00
0,01 -- true
0,10 -- true
1,00 -- true
10,00 -- true
100,00 - true
1.000,00 -- true
10.000,00 -- true
100.000,00 --true
1.000.000,00 -- true
10.000.000,00 -- true
100.000.000,00 -- true
1.000.000.000,00 -- true

0,00
00,00
000,00
0000,00
0,01 -- true
0,10 -- true
1,00 -- true
10,00 -- true
100,00 - true
1000,00 -- true
10000,00 -- true
100000,00 --true
1000000,00 -- true
10000000,00 -- true
100000000,00 -- true
1000000000,00 -- true

Regular Expressions 101

Regular Expression

Test String
New

Extraction
Processing...

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...