String

[sudeshnasen]

I need to extract the part in brackets only. How do i do this in alteryx?

alex13(alexander)

bhu23(bhushan)

kip1(kipling)

ra3(ray)

bet22(betsy)

The output will be 

alexander

bhusan

kipling

ray

betsy

[TomWelgemoed · Accepted solution]

Hi,

You can just use a Text To Columns tool and use '(' as a delimiter.

That would parse the bits in brackets to a new column.

Regards,

Tom

[TomWelgemoed]

Thanks for accepting the solution!

FYI, if you had to use Regex, something like this could work: (\([a-z]+\))

You would choose the output method of "Parse".