Regular Expressions 101

1st Alternative(?<=,|^)(?:[0.+-]+(?=0(?:,|\.\B|$))|0+(?=[1-9]))

Positive Lookbehind(?<=,|^)

1st Alternative,

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

2nd Alternative^

^start of string

Non-Capturing Group(?:[0.+-]+(?=0(?:,|\.\B|$))|0+(?=[1-9]))

1st Alternative[0.+-]+(?=0(?:,|\.\B|$))

Character Class[0.+-]+

+matches at least one character from the set below:

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

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

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

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

Positive Lookahead(?=0(?:,|\.\B|$))

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

Non-Capturing Group(?:,|\.\B|$)

1st Alternative,

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

2nd Alternative\.\B

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

\Bnot an ASCII word boundary

3rd Alternative$

$end of string, or before its final line terminator

2nd Alternative0+(?=[1-9])

0+the literal 0 (48₁₀ / 60₈ / 30₁₆) , repeated at least once

Positive Lookahead(?=[1-9])

Character Class[1-9]

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

2nd Alternative\.0+\b

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

0+the literal 0 (48₁₀ / 60₈ / 30₁₆) , repeated at least once

\ban ASCII word boundary

3rd Alternative\b0+(?=\d*\.\b)

\ban ASCII word boundary

0+the literal 0 (48₁₀ / 60₈ / 30₁₆) , repeated at least once

Positive Lookahead(?=\d*\.\b)

\d*a digit, repeated any number of times

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

\ban ASCII word boundary

4th Alternative\.\B

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

\Bnot an ASCII word boundary

5th Alternative(?<=[1-9])0+(?=,|$)

Positive Lookbehind(?<=[1-9])

Character Class[1-9]

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

0+the literal 0 (48₁₀ / 60₈ / 30₁₆) , repeated at least once

Positive Lookahead(?=,|$)

1st Alternative,

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

2nd Alternative$

$end of string, or before its final line terminator

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?<=,|^)(?:[0.+-]+(?=0(?:,|\.\B|$))|0+(?=[1-9]))|\.0+\b|\b0+(?=\d*\.\b)|\.\B|(?<=[1-9])0+(?=,|$)

New

2.0,3.00,-4.0,0.00,-0.00,0.03,2.01,0.001,-0.03,101,-00.,0.,01,1.10,000.,.000,0.000,-004.04

Regular Expression

Extraction