Regular Expressions 101

-?optionally matches the literal - (45₁₀ / 55₈ / 2D₁₆)

Character Class[0-9]{1,3}

{1,3}matches between 1 and 3 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Non-Capturing Group(?: ?[0-9]{3})*

*repeats the group contents below any number of times:

?optionally matches the literal (32₁₀ / 40₈ / 20₁₆)

Character Class[0-9]{3}

{3}matches exactly 3 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Character Class[.,]

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

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

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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-9]{1,3}(?: ?[0-9]{3})*[.,][0-9]{2}

New

1 000.00
1000,00
343 444.45
Subtotal,    1 000.00 EUR
VAT    1000,00
Total, sum:    -343 444.45 EUR