Regular Expressions 101

Negative Lookahead(?!\B"[^"]*)

\Bnot an ASCII word boundary

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

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

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

Negative Lookahead(?![^"]*"\B)

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

\Bnot an ASCII word boundary

Global pattern flags

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?!\B"[^"]*),(?![^"]*"\B)

New

bob jones,123,55.6,,,"Hello , World",,0
jim neighbor,432,66.5,,,Andy "Blank,,1
john smith,555,77.4,,,Some value,,2