Regular Expressions 101

Pro

substrthe literal text substr (case insensitive)

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

Negated Character Class[^()]*

*matches any number of characters outside the set below:

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

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

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

\h*any horizontal whitespace character, repeated any number of times

Non-Capturing Group(?:=\h*'[^']*'|IN\h*$[^()]*$)

1st Alternative=\h*'[^']*'

=the literal = (61₁₀ / 75₈ / 3D₁₆)

\h*any horizontal whitespace character, repeated any number of times

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

Negated Character Class[^']*

*matches any number of characters outside the set below:

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

2nd AlternativeIN\h*$[^()]*$

INthe literal text IN (case insensitive)

\h*any horizontal whitespace character, repeated any number of times

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

Negated Character Class[^()]*

*matches any number of characters outside the set below:

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

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

\)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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

No unit tests · Add a test to get started

25 tokens

substr\([^()]*\)\h*(?:=\h*'[^']*'|IN\h*\([^()]*\))

There are no unit tests, click to add some.