Regular Expressions 101

\ban ASCII word boundary

\d+a digit, repeated at least once

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

*repeats the group contents below any number of times:

Non-Capturing Group(?:\.|,)

1st Alternative\.

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

2nd Alternative,

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

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

Non-Capturing Group(?:(?:\.|,)\d{2})

Non-Capturing Group(?:\.|,)

1st Alternative\.

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

2nd Alternative,

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

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

\ban ASCII word boundary

Negative Lookahead(?!\W\d)

\Wany non-word character

\da 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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

\b\d+(?:(?:\.|,)\d{3})*(?:(?:\.|,)\d{2})\b(?!\W\d)

New

Beschreibung Menge VK-Preis MwSt% Betrag
Schadenbewertunginkl.Restwertermittlung 1 25,00€ 19 25,00€
Rechnungsbetragexcl.MwSt.: 25,00€
MwSt.(19%): 4,75€
Rechnungsbetragincl.MwSt.: 123.029,75€
Gutachtennummer: 1009126 Leistungsdatum: 11.10.2021
$12.55

Regular Expression

Extraction