Separating Name and ID Code

HI Guys,

Can I seek your assistance how can I separate this for example -- Victor, Buenaventura (C235478) into Victor, Buenaventura and another column C235478. I'm trying to use the regex but unable to get correct output. Please do also include how you arrive the solution. Thanks.

Kamen

Workflow

Regex

Parse

Common Use Cases

Accepted answers

binu_acs

@KamenRider

[^\(\)]+

All comments

dougperez

See the workflow attached

parsenamecode.yxmd

KamenRider

Hi @dougperez

Can we removed the open and close parenthesis? should be C235478 only.

dougperez

Yup, the regex will be:

(\w+,\s\w+) \(([\S]+)\)

binu_acs

@KamenRider

[^\(\)]+

KamenRider

Hi @binu_acs

Nice, this works although I need to remove the trailing spaces it created but still it solve. May I know what those characters mean and what do you mean by "tokenize"

Thanks,

Kamen

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703