regex101: PCRE (Legacy) Match Workspace

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

Group arguments(?<arguments>(([^\(\)']*)|(\([^\(\)']*\))|'(.*?)')*)

Group 2(([^\(\)']*)|(\([^\(\)']*\))|'(.*?)')*

*repeats the group contents below any number of times:

1st Alternative([^\(\)']*)

Group 3([^\(\)']*)

Negated Character Class[^\(\)']*

*matches any number of characters outside the set below:

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

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

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

2nd Alternative(\([^\(\)']*\))

Group 4(\([^\(\)']*\))

\(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 ' (39₁₀ / 47₈ / 27₁₆)

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

3rd Alternative'(.*?)'

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

Group 5(.*?)

.*?any character (except for line terminators), repeated any number of times

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

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

Global pattern flags

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

Search reference

Regular Expression

\((?<arguments>(([^\(\)']*)|(\([^\(\)']*\))|'(.*?)')*)\)

Test String
New

Find arguments inside balanced parenthesis.
Regex idea from Marco  https://stackoverflow.com/a/10596403/1898524


( arg1, arg2, arg3, (arg4), '(pip' )
trim(( arg1, arg2, arg2a, arg3, (arg4), '(pip' ))
SELECT ISNULL(string,   left(1,13)     )

SELECT ISNULL(string,'x'   )
SELECT ISNULL(string,   char(13)     )
SELECT ISNULL(string, char(13) ), ISNULL(string, 'x' )

ISNULL( x )
ISNULL( char(13))


SELECT MID(LTRIM(RTRIM(ISNULL(string, char(13)))),4,8)  <-- Does not work on a heavily nested function.

Regular Expressions 101

Regular Expression

Test String
New

Extraction
Processing...

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...