We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

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

Separate data in one column in 2 with delimiter "space"+"dash"+"Space.

bigdaddyvette
7 - Meteor

Can Someone assist me in separating Text to Columns with 3 delimiters.... delimiters are (space)(dash)(space). into 2 columns.... for example separating "Garcia-Morales, Fred - E123456" attempting to get result of second column to be just "E123456"?

6 REPLIES 6
fmvizcaino
16 - Nebula
16 - Nebula

Hi @bigdaddyvette ,

 

Attached is a solution showing how to do it with regex and text to columns also.

fmvizcaino_0-1583193703298.png

 

 

Let me know if this makes sense to you.

BEst,

Fernando Vizcaino

AlexBibin
8 - Asteroid

This works:

AlexBibin_0-1583193965314.png

 

MarqueeCrew
19 - Altair
19 - Altair

You could use a Replace function as:

 

replace([field]," - ", '|')

 

 then use a text to columns with the pipe | as the delimiter. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
bigdaddyvette
7 - Meteor

Thank You 🙂

bigdaddyvette
7 - Meteor

Thank You

bigdaddyvette
7 - Meteor

Appreciate It, thks

Labels