Regular Expressions 101

Pro

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.

26 tokens

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

Extraction

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