Extract data from inside parentheses that also has nested data inside parentheses

[krandol5]

Okay difficult to explain so I apologize in advance if this does not come across well.

In my workflow I am extracting data from inside parentheses using this RegEx code:

.*\((.*)\).*

I thought it was working perfect, but I discovered there was an error because some of my data in parentheses also contains a parentheses with data. It's only grabbing the nested parentheses. So, how can I grab the data in parentheses INCLUDING the nested parentheses?

Here is an example:

DUPONT, EDWARD C. JR (Board Member - Treasurer (part year))

I want to extract the entire parentheses: (Board Member - Treasurer (part year))

Currently with the above RegEx code it's coming out like this, only grabbing the inner parentheses:

Organization                                         EIN            Name                                   Title
MARTINS POINT HEALTH CARE INC 010353275 DUPONT, EDWARD C. JR) part year)

I'm attaching my workflow here, I will probably have some more questions while working on this workflow in the future. Thank you in advance for the assistance!

[Qiu · Accepted solution]

@krandol5 
Since your input data in missing from the workflow you provided, can you try the lazy mode for the part you dont want.

[krandol5]

Exactly what I needed, thank you!

[Qiu]

@krandol5 
Great and thank you also for the accept mark. 😁