Extracting all sets of brackets

[ImranBhatti]

Hi,

I have a variable string that could be like this

myStr = ((ab OR dc) AND (ef OR G OR mg) AND (aF OR abd OR what ever))

The output I want is
ab OR dc
ef OR G OR mg
aF OR abd OR what ever

Help would be greatly appreciated

Best Regards
Imran Bhatti

[jindon]

Please Login or Register  to view this content.

[Rick Rothstein]

Here is a function that can be used within your own VBA code or as a UDF (user defined function) in a worksheet formula...

Please Login or Register  to view this content.

Examples:

Within VBA Code
--------------------------------
MyStr = "((ab OR dc) AND (ef OR G OR mg) AND (aF OR abd OR what ever))"
MsgBox Brackets(MyStr)

As a UDF in a cell
--------------------------------
=Brackets(A1)

NOTE: If you use is as a UDF, don't forget to turn Wrap Text on for the cell you put the formula in.

[ImranBhatti]

@jindon. it worked as expected. Hat's off to you

[ImranBhatti]

Here is a function that can be used within your own VBA code or as a UDF (user defined function) in a worksheet formula...

Please Login or Register  to view this content.

Examples:

Within VBA Code
--------------------------------
MyStr = "((ab OR dc) AND (ef OR G OR mg) AND (aF OR abd OR what ever))"
MsgBox Brackets(MyStr)

As a UDF in a cell
--------------------------------
=Brackets(A1)

NOTE: If you use is as a UDF, don't forget to turn Wrap Text on for the cell you put the formula in.

Your solution produced an error like the attached.

[rorya]

You need to add:

Please Login or Register  to view this content.

or use:

Please Login or Register  to view this content.

for the parameter.

[ImranBhatti]

Thanks rory for the correction. it is working and now I have 2 solutions.

[jindon]

JFYI,

Works differently when string like

e.g.
"(((a and b) + (c or d) *(e or f) and (g or h))) or something else"

Mine is only extract in between opening bracket and closing bracket and ignore other.

[ImranBhatti]

Thanks jindon, chances are more than 2 brackets in the beginning and ending but no chance of non alpha characters in my situation. I will post a new thread if I come across such situation during my project.

Thanks once again for pointing out.

[Rick Rothstein]

Your solution produced an error like the attached.

I always declare my variables as to their data type (myStr As String for this one), but you left it as a Variant (the default data type) which is why the error occurred. Thanks to rorya for providing the correction. I usually remember to use the ByVal when posting in forums, but for some reason I forgot this time.

[round99]

Brilliant - I had a very similar issue and this really helped!