Regular Expressions 101

Pro

^start of line

Group 1([^"\r\n]*(?:(?:"[^"]*")*[^"\r\n]*))

Negated Character Class[^"\r\n]*

*matches any number of characters outside the set below:

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

\ra carriage return (ASCII 13)

\na line-feed (newline) character (ASCII 10)

Non-Capturing Group(?:(?:"[^"]*")*[^"\r\n]*)

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

*repeats the group contents below any number of times:

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

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

Negated Character Class[^"\r\n]*

*matches any number of characters outside the set below:

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

\ra carriage return (ASCII 13)

\na line-feed (newline) character (ASCII 10)

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

^([^"\r\n]*(?:(?:"[^"]*")*[^"\r\n]*))

New

row1 col1|"row1 ""col2a""
row1 ""col2b"""|row1 col3
row2 col1|"row2 col2a
row2 col2b"|row2 col3
row3 col1|"row3 col2a
row3 col2b"|row3 col3

row1 col1|"row1 ""col2a""
row1 ""col2b"""|row1 col3
row2 col1|"row2 col2a
row2 col2b"|row2 col3
row3 col1|"row3 col2a
row3 col2b"|row3 col3