Regular Expressions 101

Pro

Non-Capturing Group(?:“[^“”]+”|"[^"]+"|(?<=,|^)[^“”,"]+(?=(?:,|$)))

1st Alternative“[^“”]+”

“the literal “ (8220₁₀ / 20034₈ / 201C₁₆)

Negated Character Class[^“”]+

+matches at least one character outside the set below:

“the literal “ (8220₁₀ / 20034₈ / 201C₁₆)

”the literal ” (8221₁₀ / 20035₈ / 201D₁₆)

2nd Alternative"[^"]+"

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

Negated Character Class[^"]+

+matches at least one character outside the set below:

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

3rd Alternative(?<=,|^)[^“”,"]+(?=(?:,|$))

Positive Lookbehind(?<=,|^)

1st Alternative,

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

2nd Alternative^

^start of line

Negated Character Class[^“”,"]+

+matches at least one character outside the set below:

“the literal “ (8220₁₀ / 20034₈ / 201C₁₆)

”the literal ” (8221₁₀ / 20035₈ / 201D₁₆)

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

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

Positive Lookahead(?=(?:,|$))

Non-Capturing Group(?:,|$)

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

Detailed match information will be displayed here automatically.

25 tokens

(?:“[^“”]+”|"[^"]+"|(?<=,|^)[^“”,"]+(?=(?:,|$)))

New

sunil,"foo, bar","abc,xyz",anil tiwari,"akhilesh,sun", "first,second,third", "test", “this is a test”,word
400,test,"don't split, this",15

sunil,"foo, bar","abc,xyz",anil tiwari,"akhilesh,sun", "first,second,third", "test", “this is a test”,word
400,test,"don't split, this",15