Delete everything between brackets , even when nested

I have a small macro which deletes everything between brackets

Please Login or Register  to view this content.

This works fine , but fails where the brackets are nested.

So for example

Salsoul Orchestra - Runaway (CD, Maxi) (Club Classics (2) - CLCL 012)

becomes

Salsoul Orchestra - Runaway - CLCL 012).

when it should be

Salsoul Orchestra - Runaway

Can someone suggest some VBA which will cope with nested brackets and delete everything within them?

Grateful for any advice.

Try this pattern but repeat your find & replace at least twice.

\([!\(]@\)

This will delete nested brackets from inside out but requires a second pass to get the outer ones. I added a third one in off chance that you have nesting to three levels.

Please Login or Register  to view this content.

If this does not work please provide a sample Word file for testing.

Another more complicated but more powerful method is to use regexp, which is greedy. Word pattern matching is lazy.

Thanks 6StringJazzer - this works perfectly and solves the issue. Problem solved!

You're welcome and thanks for the rep!

Better:

Please Login or Register  to view this content.

Yes, that's better, I was unaware of the Found property.

Your point being? Did you actually examine & test the solutions posted?

Originally Posted by ribiwo1345

When dealing with text that contains nested brackets, like "Salsoul Orchestra - Runaway (CD, Maxi) (Club Classics (2) - CLCL 012)," it's crucial to have a VBA script that can handle such complexity. The provided VBA solution needs to accurately remove all content enclosed in brackets, including those nested within each other. A reliable approach involves using a recursive function that processes each level of nested brackets until all are removed. If you're looking to improve your VBA script for this purpose, ensure it can handle multiple layers of nesting to achieve a clean, bracket-free result. For more detailed guidance, check out specialized VBA forums or tutorials.

This looks like an AI response. Not a good look for your first post. Plus the thread is already marked SOLVED. Plus the post contributes nothing to a solution.

If this continues you are subject to infractions up to banning.