Regular Expressions 101

Pro

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

Negative Lookbehind(?<!\d)

\da Unicode decimal digit

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

?repeats the group contents below at most once:

1st Alternative\d{1,3}(?:,\d{3})*

\d{1,3}a Unicode decimal digit, repeated between 1 and 3 times

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

*repeats the group contents below any number of times:

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

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

2nd Alternative\d{4,}

\d{4,}a Unicode decimal digit, repeated at least 4 times

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

\d+a Unicode decimal digit, repeated at least once

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.

25 tokens

Regular Expression

\$?(?<!\d)(?:\d{1,3}(?:,\d{3})*|\d{4,})?\.?\d+

New

"Transfer to Retirement Rsvs-MA FX                   .11"                
"Opening Balance                FX        342,536,002.63"     
"VA                 85.85"               
"VB                   .00"     
"Manual Adjustment              FX              6,838.36-"

Extraction

"Transfer to Retirement Rsvs-MA FX                   .11"                
"Opening Balance                FX        342,536,002.63"     
"VA                 85.85"               
"VB                   .00"     
"Manual Adjustment              FX              6,838.36-"