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
Harsh