regex101: PCRE (Legacy) Match Workspace

^start of line

Positive Lookahead(?=-.*D$|\d.*C$)

1st Alternative-.*D$

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

.*any character (except for line terminators), repeated any number of times

Dthe literal D (68₁₀ / 104₈ / 44₁₆) (case sensitive)

$end of line

2nd Alternative\d.*C$

\da digit

.*any character (except for line terminators), repeated any number of times

Cthe literal C (67₁₀ / 103₈ / 43₁₆) (case sensitive)

$end of line

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

Positive Lookahead(?=(?:\d,?){1,13}\.)

Non-Capturing Group(?:\d,?){1,13}

{1,13}repeats the group contents below between 1 and 13 times:

\da digit

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

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

Non-Capturing Group(?:0|[1-9]\d{0,2}(?:,\d{3})*)

1st Alternative0

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

2nd Alternative[1-9]\d{0,2}(?:,\d{3})*

Character Class[1-9]

1-9one character from 1 (49₁₀) to 9 (57₁₀)

\d{0,2}a digit, repeated between 0 and 2 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

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

Character Class[DC]

Dthe literal D (68₁₀ / 104₈ / 44₁₆) (case sensitive)

Cthe literal C (67₁₀ / 103₈ / 43₁₆) (case sensitive)

$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

25 tokens

Regular Expression

^(?=-.*D$|\d.*C$)-?(?=(?:\d,?){1,13}\.)(?:0|[1-9]\d{0,2}(?:,\d{3})*)\.\d{2} [DC]$

New

-0.48 D
-1.00 D
-2,000.00 D
-100,000.56 D
-100,000.00 D
-1,123,456.43 D
-1,123,456,000,000.43 D
-10,123,456,000,000.43 D
-1,123,456.43 C
-3,000,62.45 D
-03,000.45 D
-.23 D

0.23 C
1.00 C
2,000.00 C
100,000.56 C
100,000.00 C
1,123,456.43 C
1,123,456,000,000.43 C
10,123,456,000,000.43 C

Extraction

-0.48 D
-1.00 D
-2,000.00 D
-100,000.56 D
-100,000.00 D
-1,123,456.43 D
-1,123,456,000,000.43 D
-10,123,456,000,000.43 D
-1,123,456.43 C
-3,000,62.45 D
-03,000.45 D
-.23 D

0.23 C
1.00 C
2,000.00 C
100,000.56 C
100,000.00 C
1,123,456.43 C
1,123,456,000,000.43 C
10,123,456,000,000.43 C