regex101: PCRE (Legacy) Match Workspace

Non-Capturing Group(?:^|\;)

1st Alternative^

^start of line

2nd Alternative\;

\;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Positive Lookahead(?=[^"]|(")?)

1st Alternative[^"]

Negated Character Class[^"]

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

2nd Alternative(")?

Group 1(")?

?repeats the group contents below at most once:

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

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

Group 2((?(1)[^"]*|[^\;"]*))

Condition(?(1)[^"]*|[^\;"]*)

Uses the first branch if group 1 matched

If the condition is true, match this branch:[^"]*

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

Otherwise, match this branch:[^\;"]*

Negated Character Class[^\;"]*

*matches any number of characters outside the set below:

\;the literal ; (59₁₀ / 73₈ / 3B₁₆)

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

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

Positive Lookahead(?=\;|$)

1st Alternative\;

\;the literal ; (59₁₀ / 73₈ / 3B₁₆)

2nd Alternative$

$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

25 tokens

Regular Expression

(?:^|\;)(?=[^"]|(")?)"?((?(1)[^"]*|[^\;"]*))"?(?=\;|$)

New

"Code";City;Country/Region Code;County
01067;Dresden;DE;Sachsen
01067;"Dresden Friedrichstadt";DE;Sachsen
01067;Dresden Innere Altstadt;DE;Sachsen
01069;Dresden;DE;Sachsen
01097;Dresden;DE;Sachsen
01099;Dresden;DE;Sachsen
01108;Dresden;DE;Sachsen

Substitution

"Code";City;Country/Region Code;County
01067;Dresden;DE;Sachsen
01067;"Dresden Friedrichstadt";DE;Sachsen
01067;Dresden Innere Altstadt;DE;Sachsen
01069;Dresden;DE;Sachsen
01097;Dresden;DE;Sachsen
01099;Dresden;DE;Sachsen
01108;Dresden;DE;Sachsen