Regular Expressions 101

Explanation

Pro

^start of line

Positive Lookahead(?=(?:\d,?){1,10}(?:\.\d{2})?$)

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

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

\da digit

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

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

?repeats the group contents below at most once:

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

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

$end of line

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:

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

Character Class[0-9]{3}

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

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

Non-Capturing Group(?:\.[0-9]+)?

?repeats the group contents below at most once:

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

Character Class[0-9]+

+matches at least one character from the set below:

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

$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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

^(?=(?:\d,?){1,10}(?:\.\d{2})?$)[0-9]{1,3}(?:,[0-9]{3})*(?:\.[0-9]+)?$

New

I want to make sure that the input is no more than 10 digits before the decimals point so it will match DECIMAL(12,2).

I already tried :

^(?=.{0,13}$)[0-9]{1,3}(,[0-9]{3})*(\.[0-9]+)?$
But it counts the digits after decimals too, so what I want to match is:

1,111,111,111.00

so it will keep matching with or without the decimals, what I tried only can match with:

1,111,111,111

111,111,111.00

1,111,111,111,1.00

Extraction

I want to make sure that the input is no more than 10 digits before the decimals point so it will match DECIMAL(12,2).

I already tried :

^(?=.{0,13}$)[0-9]{1,3}(,[0-9]{3})*(\.[0-9]+)?$
But it counts the digits after decimals too, so what I want to match is:

1,111,111,111.00

so it will keep matching with or without the decimals, what I tried only can match with:

1,111,111,111

111,111,111.00

1,111,111,111,1.00