Removing text in () ina text string

[BosKev]

Hi,

is there a way for me to remove all text within parenthesis () of a longer text string?

for example: SERVICE RENDERED: INITIAL: DEPENDENT VISA FOR DAUGHTER (xxxxx) (STAND ALONE) (xxxx) ;GOVERNMENT FEES PAID. HKD 000

text string length varies.

Thanks.

-KW

[Garrett · Accepted solution]

How about some RegEx: \(.*?\)

[PeterGoldey]

This can be done using the REGEX tool.

(yes, its hard to get the hang of the syntax - I struggle with it all the time).

Try this: \(.*\) as replace in the tool

(same solution just posted above)

[danilang]

Hi @BosKev 

Try

Edit:  And another identical solution

Dan

[BosKev]

Thanks all, Regex worked like a charm! was looking into fuzzy match - name match but that process was getting more complicated by the minute.