Regular Expressions 101

Pro

Group 1(.*,)

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

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

Group 2(\"\"[^,].*\"\")

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

Negated Character Class[^,]

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

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

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

Group 3(,.*)

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

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

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

(.*,)(\"\"[^,].*\"\")(,.*)

New

column1,column2,column3,column4,column5,column6
123,"some text",""column3 text"",4,234,""

123,"some text",""column3 text"",""still column3 text"",4,234,""

Substitution

column1,column2,column3,column4,column5,column6
123,"some text",""column3 text"",4,234,""

123,"some text",""column3 text"",""still column3 text"",4,234,""