Removing text in () ina text string

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

Datasets

Tips and Tricks

Transformation

Help

Fuzzy Match

Data Investigation

Accepted answers

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

All comments

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

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)

Try

Edit: And another identical solution

Dan

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

Quick Links

Tags

This months top contributors

erich_shiino 280