We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Extract using right most delimiter

zchotani
7 - Meteor

Hello,

I need help to get text in a separate column/field using the right most delimeter. Example below:

MN-Owatonna - 26th - Ortho Clinician ---> New Column = Ortho Clinician

 

Can someone please help. I suppose this will require RegEx under parsing.

11 REPLIES 11
ChrisTX
16 - Nebula
16 - Nebula

Have you tried   .*\-\s(.*)   ?

 

Did it not work?  Can you provide more input data examples?

Christina_H
14 - Magnetar

@zchotani I'm not sure which solution you're saying didn't work.  Mine isn't specific to "Ortho Clinician", it's locating one or two numbers followed by two letters, followed by optional space/hyphen, and returning everything following.

Christina_H_0-1675868591459.png

Labels
Top Solution Authors