Regular Expressions 101

Explanation

Pro

\s*any whitespace character, repeated any number of times

Group 1(")?

?repeats the group contents below at most once:

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

Group 2(.*?)

.*?any character (except for line terminators), repeated any number of times

\1the text saved by group 1

\s*any whitespace character, repeated any number of times

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.

26 tokens

\s*(")?(.*?)\1\s*(?:,|$)

New

name,age,booktitle
John,,Hello World
Mary,3,""Alas, What Can I do?""
Joseph,5,"Waiting, waiting, waiting"
"Donaldson Jones" , six,	 "Hello, friend!"

name,age,booktitle
John,,Hello World
Mary,3,""Alas, What Can I do?""
Joseph,5,"Waiting, waiting, waiting"
"Donaldson Jones" , six,	 "Hello, friend!"