Regular Expressions 101

Pro

^start of line

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

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

{8}repeats the group contents below exactly 8 times:

Negated Character Class[^,]*

*matches any number of characters outside the set below:

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

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

Group 1([^,"]*)

Negated Character Class[^,"]*

*matches any number of characters outside the set below:

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

"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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

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

New

Home_TE,-2.8,1,"-",-,-,-,1,"-",-,-,-,"-",1,-,"-","-",-,-,MIL_TT
Home_TE,-2.8,1,"-",-,-,-,1,123,-,-,-,"-",1,-,"-","-",-,-,MIL_TT
Home_TE,-2.8,1,"-",-,-,-,1,456,-,-,-,"-",1,-,"-","-",-,-,MIL_TT