Start Free Trial

Alteryx Designer Desktop Discussions

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

split into columns without using text to columns tool

Raj008
8 - Asteroid

Hi,

 

I do have a data set, "5555,00,1234,ABC,/", need to know how to split this into different columns without using text to columns tool.

 

Thanks,

Raj...

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @Raj008 

 

You can use Regex tool parse. But can I know why no text to columns tool?

 

You can use Regex tool prase like below.

 

(.+),(.+),(.+),(.+),(.+)

 

 

Workflow:

atcodedog05_0-1627063574020.png

 

Hope this helps : )

mtouiti
Alteryx Alumni (Retired)

Hey Raj, 

 

In case you want to learn more about the Regex tool on alteryx here is some good resources : 

 

Tool Mastery :  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689 

some examples https://community.alteryx.com/t5/Alteryx-Designer-Discussions/RegEx-Examples-12-Handy-Use-Cases/td-p... 

 

Best of luck

mo

Labels
Top Solution Authors