regex101: PCRE (Legacy) Match Workspace

Negative Lookahead(?!\d+,\d+\.\d+,|\d+\.\d+,\d+.)

1st Alternative\d+,\d+\.\d+,

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

2nd Alternative\d+\.\d+,\d+.

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

.any character (except for line terminators)

^start of line

Group 1([+-]?(?:\d+|\d{1,3}(?:[.,]\d{3})*)(?:[.,]\d+|[eE][+-]?(?:\d+|\d{1,3}(?:[.,]\d{3})*))?)

Character Class[+-]?

?matches at most one character from the set below:

+the literal + (43₁₀ / 53₈ / 2B₁₆)

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

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

1st Alternative\d+

\d+a digit, repeated at least once

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

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

Character Class[.,]

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

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

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

Non-Capturing Group(?:[.,]\d+|[eE][+-]?(?:\d+|\d{1,3}(?:[.,]\d{3})*))?

?repeats the group contents below at most once:

1st Alternative[.,]\d+

Character Class[.,]

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

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

\d+a digit, repeated at least once

2nd Alternative[eE][+-]?(?:\d+|\d{1,3}(?:[.,]\d{3})*)

Character Class[eE]

ethe literal e (101₁₀ / 145₈ / 65₁₆) (case sensitive)

Ethe literal E (69₁₀ / 105₈ / 45₁₆) (case sensitive)

Character Class[+-]?

?matches at most one character from the set below:

+the literal + (43₁₀ / 53₈ / 2B₁₆)

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

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

1st Alternative\d+

\d+a digit, repeated at least once

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

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

Character Class[.,]

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

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

\d{3}a digit, repeated exactly 3 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

Search reference

Regular Expression

(?!\d+,\d+\.\d+,|\d+\.\d+,\d+.)^([+-]?(?:\d+|\d{1,3}(?:[.,]\d{3})*)(?:[.,]\d+|[eE][+-]?(?:\d+|\d{1,3}(?:[.,]\d{3})*))?)$

New

1
1.1
1,1
1,000,000.20
1.00000020
1.000.000,20
10.20001
24568221.94827
347,543,291.01
12e20
1e9
1e-9
1,009e10
10009e10
123,456.543
+123,456,789
-123,456,789

1,234583,213
1.234,568.78
123,456.543,456