Regular Expressions 101

Non-Capturing Group(?:^|,)

1st Alternative^

^start of line

2nd Alternative,

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

Positive Lookahead(?=[^"]|(")?)

1st Alternative[^"]

Negated Character Class[^"]

"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative(")?

Group 1(")?

?repeats the group contents below at most once:

"the literal " (34₁₀ / 42₈ / 22₁₆)

"?optionally matches the literal " (34₁₀ / 42₈ / 22₁₆)

Group 2((?(1)(?:[^"]|"")*|[^,"]*))

Condition(?(1)(?:[^"]|"")*|[^,"]*)

Uses the first branch if group 1 matched

If the condition is true, match this branch:(?:[^"]|"")*

Non-Capturing Group(?:[^"]|"")*

*repeats the group contents below any number of times:

1st Alternative[^"]

Negated Character Class[^"]

"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative""

""the literal text ""

Otherwise, match this branch:[^,"]*

Negated Character Class[^,"]*

*matches any number of characters outside the set below:

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

"the literal " (34₁₀ / 42₈ / 22₁₆)

"?optionally matches the literal " (34₁₀ / 42₈ / 22₁₆)

Positive Lookahead(?=,|$)

1st Alternative,

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

2nd Alternative$

$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

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?:^|,)(?=[^"]|(")?)"?((?(1)(?:[^"]|"")*|[^,"]*))"?(?=,|$)

New

,2.99,AMO024,Title,"Description, more info",,123987564
123,2.99,AMO024,Title,"Description, more info",,123987564
"""test"" test","test""fdas""fdad",