Hi,
Please consider these two cases

A=F1 (Plan 99 \Old Plan 100\)472 676 w
A=F1 (Plan 99 \(Old Plan 100\))472 676 w

I need to Extract the Text Between the two Brackets i.e "(" and ")"

If I use STREXTRACT(A,'(',')'), for the first Case I get " Plan 99 \Old Plan 100\", which is correct as per my requirement.

But I get "Plan 99 \(Old Plan 100\" for my second case while It need "Plan 99 \(Old Plan 100\)".

I Need to extract the Text Between Two Extreme Brackets. How to do this in both the above situation.

Thanks