regex101: PCRE (Legacy) Match Workspace

Pro

1st Alternative"[^\\"]*(?:\\[\w\W][^\\"]*)*"

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

Negated Character Class[^\\"]*

*matches any number of characters outside the set below:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

Non-Capturing Group(?:\\[\w\W][^\\"]*)*

*repeats the group contents below any number of times:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

Character Class[\w\W]

\wany word character

\Wany non-word character

Negated Character Class[^\\"]*

*matches any number of characters outside the set below:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

2nd Alternative'[^\\']*(?:\\[\w\W][^\\']*)*'

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

Negated Character Class[^\\']*

*matches any number of characters outside the set below:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

Non-Capturing Group(?:\\[\w\W][^\\']*)*

*repeats the group contents below any number of times:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

Character Class[\w\W]

\wany word character

\Wany non-word character

Negated Character Class[^\\']*

*matches any number of characters outside the set below:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

3rd Alternative(:\w+)

Group 1(:\w+)

:the literal : (58₁₀ / 72₈ / 3A₁₆)

\w+any word character, repeated at least once

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

"[^\\"]*(?:\\[\w\W][^\\"]*)*"|'[^\\']*(?:\\[\w\W][^\\']*)*'|(:\w+)

New

select * from a where id = :myId3;
to_timestamp_tz(:FROM_DATE, 'YYYY-MM-DD\"T\"HH24:MI:SS')
TO_CHAR(ep.CHANGEDT,'yyyy=mm-dd hh24:mi:ss')

user input invalid string ' :shouldIgnoreThisNamedParam ' in a string

Substitution

select * from a where id = :myId3;
to_timestamp_tz(:FROM_DATE, 'YYYY-MM-DD\"T\"HH24:MI:SS')
TO_CHAR(ep.CHANGEDT,'yyyy=mm-dd hh24:mi:ss')

user input invalid string ' :shouldIgnoreThisNamedParam ' in a string