I am working on troubleshooting an aspect of one program, and had a situation where I wanted to remove all text in between parenthesis (from an output block), and leave the text within the parenthesis intact, and each on it’s own line. Obviously, this can be done manually, but I had a ton of records, and prefer finding find/replace solutions for situations like this. I ended up creating a wildcard: \)*\(*\(
The replace keyword I used was ^p, which inserts a new line in place of the text it replaces.
The first and last record must be manually removed, but this did the majority of the work for me, and I’m happy. I don’t claim to be a regular expression expert in any way, so I’m sure there may be a better way about this, but I figured I would share anyways.