Regular Expressions 101

Pro

^start of line

Non-Capturing Group(?:"[^"]*",){1}

{1}repeats the group contents below exactly 1 time:

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

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

",the literal text ",

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

Group 1([^"]*)

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

^(?:"[^"]*",){1}"([^"]*)"

New

"01","35005","AL","ADAMSVILLE",86.959727,33.588437,10616,0.002627
"05","72001","AR","ADONA",92.903325,35.046956,494,0.00021
"06","90804","CA","SIGNAL HILL",118.155187,33.782993,36092,0.001213

Substitution

$1chat/$2

"01","35005","AL","ADAMSVILLE",86.959727,33.588437,10616,0.002627
"05","72001","AR","ADONA",92.903325,35.046956,494,0.00021
"06","90804","CA","SIGNAL HILL",118.155187,33.782993,36092,0.001213