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