regex101: PCRE (Legacy) Substitution Workspace

1st Alternative^\$\-?([1-9]{1}[0-9]{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$

^start of line

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

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

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

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

Character Class[1-9]{1}

{1}matches one character from the set below:

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

Character Class[0-9]{0,2}

{0,2}matches between 0 and 2 characters from the set below:

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

Group 2(\,\d{3})*

*repeats the group contents below any number of times:

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

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

Group 3(\.\d{0,2})?

?repeats the group contents below at most once:

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

\d{0,2}a digit, repeated between 0 and 2 times

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

Character Class[1-9]{1}

{1}matches one character from the set below:

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

\d{0,}a digit, repeated any number of times

Group 4(\.\d{0,2})?

?repeats the group contents below at most once:

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

\d{0,2}a digit, repeated between 0 and 2 times

3rd Alternative0(\.\d{0,2})?

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

Group 5(\.\d{0,2})?

?repeats the group contents below at most once:

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

\d{0,2}a digit, repeated between 0 and 2 times

4th Alternative(\.\d{1,2})

Group 6(\.\d{1,2})

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

\d{1,2}a digit, repeated between 1 and 2 times

$end of line

2nd Alternative^\-?\$([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$

^start of line

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

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

Group 7([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))

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

Character Class[1-9]{1}

{1}matches one character from the set below:

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

\d{0,2}a digit, repeated between 0 and 2 times

Group 8(\,\d{3})*

*repeats the group contents below any number of times:

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

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

Group 9(\.\d{0,2})?

?repeats the group contents below at most once:

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

\d{0,2}a digit, repeated between 0 and 2 times

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

Character Class[1-9]{1}

{1}matches one character from the set below:

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

\d{0,}a digit, repeated any number of times

Group 10(\.\d{0,2})?

?repeats the group contents below at most once:

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

\d{0,2}a digit, repeated between 0 and 2 times

3rd Alternative0(\.\d{0,2})?

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

Group 11(\.\d{0,2})?

?repeats the group contents below at most once:

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

\d{0,2}a digit, repeated between 0 and 2 times

4th Alternative(\.\d{1,2})

$end of line

3rd Alternative^$\$([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$$

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Search reference

Regular Expression

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

New

$100,351,000.58

Regular Expressions 101

Regular Expression

Extraction