Regex to remove characters inbetween ( )

[RogerA]

I need to completely remove any characters in between pairs of brackets, so my data looks something like:

AB1234 (45-78) This is a widget 

And want it to look like:

AB1234 This is a widget 

Thanks

[LordNeilLord · Accepted solution]

Hey @RogerA

Try: \(.*\)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[RogerA]

Perfect thank you!  One day i will get the hang on this.

[LordNeilLord]

Here's an alternative using the formula tool :)

[RogerA]

Thanks for all the help so far, i have just seen an anomaly in my data along the lines of:

AB1234 (98-44) This is a widget (66-45)

This has two sets of brackets, and the above solution when applied on this one removes everything after AB1234.  How can i amend the regex to make it look like:

AB1234 This is a widget

[LordNeilLord · Accepted solution]

Hey @RogerA

If you add a question mark after the star it will capture both:

[RogerA]

Thanks worked great

[Nandy]

Hi Neil,

not exactly same situation, i need to remove certain positions of the string . say string of length 20 , i need to replace 10th to 12 position of the string as blank irrespective of any value. Could you offer some help