Extract strings in a pattern from within another regex pattern: REGEX (Replace, Extract $1)

Question

How can I extract strings in a pattern from within another regex pattern Exemple:

REGEXREPLACE("Ex.: <a;b;c;> e <d;e;>.","<(.*?)>","($1)...")

to get

Ex: (a)(b)(c) e (d)(e).

Answer 1

Suggestion:

You can try a nested REGEXREPLACE functions then use SUBSTITUTE at the end like this sample below:

=SUBSTITUTE(REGEXREPLACE
           (REGEXREPLACE
           (REGEXREPLACE
           ("<a;b;c;> e <d;e;>.", "<(.*?)>", "($1)"),
            "[^a-z()> .a-z]", ")*("),
            "[^a-z()> .a-z]",""),
           "()","")

Sample Demonstration

Sample string is on cell A2

How it works:

1. Used your original regex:

E.g. placed on cell A2

=REGEXREPLACE("<a;b;c;> e <d;e;>.", "<(.*?)>", "($1)")

Result: (a;b;c;) e (d;e;).

2. Replace ; with )*(:

=REGEXREPLACE(A2, "[^a-z()> .a-z]", ")*(")

Result: (a)*(b)*(c)*() e (d)*(e)*().

3. Remove asterisk (*) sign:

=REGEXREPLACE(B2,"[^a-z()> .a-z]","")

Result: (a)(b)(c)() e (d)(e)().

4. Replace empty () using [SUBSTITUTE][2] function:

=SUBSTITUTE(C2,"()","")

Result: (a)(b)(c) e (d)(e).

Reference:

Multiple regex matches in Google Sheets formula