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