Regular Expressions 101

Pro

1st Alternative(?<=\(|',)(?=')

Positive Lookbehind(?<=\(|',)

1st Alternative\(

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

2nd Alternative',

',the literal text ',

Positive Lookahead(?=')

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

2nd Alternative(?<=')(?=\))

Positive Lookbehind(?<=')

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

Positive Lookahead(?=\))

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

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.

27 tokens

(?<=\(|',)(?=')|(?<=')(?=\))

New

Insert into table01 values('abcd01','abcd02','abcd03')

Insert into table01 values('abcd01','abcd02','abcd03')