Regular Expressions 101

Pro

1st Alternative"(?:[^"]|"")*"

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

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

*repeats the group contents below any number of times:

1st Alternative[^"]

Negated Character Class[^"]

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

2nd Alternative""

""the literal text ""

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

2nd Alternative[^,\n]+

Negated Character Class[^,\n]+

+matches at least one character outside the set below:

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

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

3rd Alternative(?=,)(?<=,)

Positive Lookahead(?=,)

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

Positive Lookbehind(?<=,)

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

4th Alternative^

^start of line

5th Alternative(?<=,)$

Positive Lookbehind(?<=,)

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

$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

s modifier: single line. Allows a dot to match line terminators

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

"(?:[^"]|"")*"|[^,\n]+|(?=,)(?<=,)|^|(?<=,)$

New

record 1:field 1,record 1:field 2,record 1:field 3
record 2:field 1,record 2:field 2,record 2:field 3
"quoted field","quoted field, with comma",  "whitespace before & affer quote"  ,"new
line in field","double quotes ""in"" field","double quotes in field "","" with comma"
,,,<- empty fields at beging, ,	,<-whitespace fields,empty fields at end ->,,


^empty records