regex101: PCRE (Legacy) Match Workspace

Comment: Only include if previous char was start of string or delimiter

Positive Lookbehind(?<=^|,)

1st Alternative^

^start of line

2nd Alternative,

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

Non-Capturing Group(?: # 1st option: empty quoted string (,'',) '{2} | # 2nd option: nothing (,,) (?:) | # 3rd option: all but quoted strings (,123,) # (included linebreaks to allow multiline matching) [^,'\r\n]+ | # 4th option: quoted strings (,'123''321',) # start pling ' (?: # double quote '{2} | # or anything but quotes [^']+ # at least one occurance - greedy )+ # end pling ' )

1st Alternative # 1st option: empty quoted string (,'',) '{2}

Comment: 1st option: empty quoted string (,'',)

'{2}the literal ' (39₁₀ / 47₈ / 27₁₆) , repeated exactly 2 times

2nd Alternative # 2nd option: nothing (,,) (?:)

Comment: 2nd option: nothing (,,)

Non-Capturing Group(?:) — does not consume characters

3rd Alternative # 3rd option: all but quoted strings (,123,) # (included linebreaks to allow multiline matching) [^,'\r\n]+

Comment: 3rd option: all but quoted strings (,123,)

Comment: (included linebreaks to allow multiline matching)

Negated Character Class[^,'\r\n]+

+matches at least one character outside the set below:

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

'the literal ' (39₁₀ / 47₈ / 27₁₆)

\ra carriage return (ASCII 13)

\na line-feed (newline) character (ASCII 10)

4th Alternative # 4th option: quoted strings (,'123''321',) # start pling ' (?: # double quote '{2} | # or anything but quotes [^']+ # at least one occurance - greedy )+ # end pling '

Comment: 4th option: quoted strings (,'123''321',)

Comment: start pling

' the literal text '

Non-Capturing Group(?: # double quote '{2} | # or anything but quotes [^']+ # at least one occurance - greedy )+

+repeats the group contents below at least once:

1st Alternative # double quote '{2}

Comment: double quote

'{2}the literal ' (39₁₀ / 47₈ / 27₁₆) , repeated exactly 2 times

2nd Alternative # or anything but quotes [^']+ # at least one occurance - greedy

Comment: or anything but quotes

Negated Character Class[^']+

+matches at least one character outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Comment: at least one occurance - greedy

Comment: end pling

' the literal text '

Comment: Only include if next char is delimiter or end of string

Positive Lookahead(?=,|$)

1st Alternative,

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

2nd Alternative$

$end of line

Global pattern flags

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

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

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

# Only include if previous char was start of string or delimiter
(?<=^|,)
(?:
  # 1st option: empty quoted string (,'',)
  '{2}
  |
  # 2nd option: nothing (,,)
  (?:)
  |
  # 3rd option: all but quoted strings (,123,)
  # (included linebreaks to allow multiline matching)
  [^,'\r\n]+
  |
  # 4th option: quoted strings (,'123''321',)
  # start pling
  ' 
    (?:
      # double quote
      '{2}
      |
      # or anything but quotes
      [^']+
    # at least one occurance - greedy
    )+
  # end pling
  '
)
# Only include if next char is delimiter or end of string
(?=,|$)

Unit Tests

There are no unit tests, click to add some.