Remove bracket with text at the end

Question

Hi All,

I am pretty new alteryx and need your help on below.

I have below input data:

ABCD (Merged)

XYZ (Converted)

DBC (Demerger) Pacific

I want below output:

ABCD

XYZ

DBC (Demerger) Pacific

So basically I want to remove bracket along with text inside at the end of the string. Leaving any brackets between or beginning.

Please help.

ShankerV · Answer

@binu_acs

I read all of your solutions, A new way to approach using the formula tool. Thanks.

Many thanks

Shanker V

ShankerV · Answer

@sirsjat21

Please find the revised solution where you wanted to remove only the ending word with brackets.

Many thanks

Shanker V

Remove bracket with text at the end.yxmd

binu_acs · Answer

@sirsjat21 One way of doing this

Regex_1207.yxmd