What I need is a function to extract the values between 2 brackets
and put a flag(or something like that) where the words 'AND' or 'OR'
are located and if they are located between 2 brackets.
For example a text can look like this:
(
(
Value1 = 1
OR
VALUE1 = 2
OR
(
VALUE1 = 3
OR
VALUE1 = 4
)
AND
Value2 = 100
Can someone help me with this?
Any help would be very appreciated.
Thanks in advance.
Paul
FYI.
The function should return a result like this:
Original
========
AND
(
(
Value1 = 1
OR
VALUE1 = 2
)
OR
(
VALUE1 = 3
OR
VALUE1 = 4
)
)
AND
Value2 = 100
Result
======
OpenFlag1
DetailFlag Value1 = 1
DetailFlag Value = 2
BetweenFlag
DetailFlag Value1 = 3
DetailFlag Value = 4
OpenFlag2
DetailFlag Value2 = 100
Thanks Paul