ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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