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
Solved! Go to 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
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".