Extract Text between Characters

[jgarciaf106]

Hi Experts,

How can I extract text between parenthesis?

Here are some samples of what is on the data source

Test (Test):  Expected Result (Test)

Test (Test (Inherited)): Expected Result (Test (Inherited))

Test (Regular) (Test(Inherited)): Expected Result (Test(Inherited)) not considering (Regular)

Any Advice?

[vishsaggi]

Great. Please close the thread marking correct /helpful responses so that others can be helpful.