Regular Expressions 101

1st Alternative(?:,"|^")((?:""|[\w\W]*?)*?)(?=",|"$)

Non-Capturing Group(?:,"|^")

1st Alternative,"

,"the literal text ,"

2nd Alternative^"

^start of line

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

Group 1((?:""|[\w\W]*?)*?)

Non-Capturing Group(?:""|[\w\W]*?)*?

*?repeats the group contents below any number of times:

1st Alternative""

""the literal text ""

2nd Alternative[\w\W]*?

Character Class[\w\W]*?

*?matches any number of characters from the set below:

\wany word character

\Wany non-word character

Positive Lookahead(?=",|"$)

1st Alternative",

",the literal text ",

2nd Alternative"$

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

$end of line

2nd Alternative(?:,(?!")|^(?!"))([^,]*?)(?=$|,)

Non-Capturing Group(?:,(?!")|^(?!"))

1st Alternative,(?!")

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

Negative Lookahead(?!")

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

2nd Alternative^(?!")

^start of line

Negative Lookahead(?!")

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

Group 2([^,]*?)

Negated Character Class[^,]*?

*?matches any number of characters outside the set below:

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

Positive Lookahead(?=$|,)

1st Alternative$

$end of line

2nd Alternative,

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

3rd Alternative(\r\n|\n)

Group 3(\r\n|\n)

1st Alternative\r\n

2nd Alternative\n

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.

Search reference

Regular Expression

(?:,"|^")((?:""|[\w\W]*?)*?)(?=",|"$)|(?:,(?!")|^(?!"))([^,]*?)(?=$|,)|(\r\n|\n)

New

normal,cell,contents
cell,"with
newline",in it
cell,"with ""quoted"" text",in it
cell,with "internal" quotes,in it
single quote,"""",cell
in cell,"quotes ""followed"", by",comma

Regular Expression

Extraction