community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Re: Text To Columns

Meteor

Would you be able to help me on the below? 

 

I am trying to split BEJING/Longdon/ Beijing? 

 

How do I split this? how do I get rid of the slash, commas ? 

 

Pls help

 

Capture.JPGPlease see the above data

Quasar

There's a Text to Columns tool. Just specify / as the delimiter. If you have more than 1 delimiter you can specify them all (e.g. /,.). Set the appropriate Number of Columns for your data.

 

Iain

Alteryx Certified Partner

Hi @zkhadi

 

The solution to your Question, is text to columns tool. What you need to do is put "/" in Delimiters (see image). I have also attached the workflow for your reference.


image.png

 

This is solution that you will get.

image.png
Happy Learning.

Meteor

Thank you so much I am unable to open the workflow do you mind send me screen shots pls many thanks !

Highlighted
Alteryx Certified Partner

HI @zkhadi,

 

Please look at the attached workflow.

Labels