Regular Expressions 101

Explanation
Pro

Non-Capturing Group(?:\G(?!^)|([^"]*(?:"[^,"]*"[^"]*)*"))

1st Alternative\G(?!^)

\Gstart of current search

Negative Lookahead(?!^)

^start of line

2nd Alternative([^"]*(?:"[^,"]*"[^"]*)*")

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

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

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 , (44₁₀ / 54₈ / 2C₁₆)

"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[^",]*

*matches any number of characters outside the set below:

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

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

\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match

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

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

?repeats the group contents below at most once:

Negated Character Class[^",]*+

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

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

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

Non-Capturing Group(?:"(?1)|$)

1st Alternative"(?1)

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

(?1)calls group 1 as a subroutine

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

(?:\G(?!^)|([^"]*(?:"[^,"]*"[^"]*)*"))[^",]*\K,([^",]*+(?:"(?1)|$))?

New

"test","this is, also a test","how could you test this?","h,i,j,k,"

Substitution

[COMMA]$2

"test","this is, also a test","how could you test this?","h,i,j,k,"