split into columns without using text to columns tool

[Raj008]

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...

[atcodedog05]

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:

Hope this helps : )

[mtouiti]

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