Split data from single column into 2 columns

[markosxman]

Hello

I would like to be able to split Column 1 into 2 columns.

One with the "number" one with the "description"

1-7811 Cash:Mizuho AUD	725,009.58
1-7812 Cash:Mizuho USD	43,767.90
1-7816 Cash:ANZ AUD	10,823.24
1-7817 Cash:Term Deposit	154,040.00
1-7823 Receivables - current:Interest receivable	75.96
1-7870 Prepayments	52,239.04

Am struggling to find the right commands!

[JosephSerpis · Accepted solution]

Hi @markosxman one approach is to use regex to split your column. The expression below will find everything up to a digit with white space and put that in column and then put everything else into a second column.

[atcodedog05]

Hi @markosxman 

You can us regex tool parse mode and below expression to split into columns.

(\d\-\d+)\s(.*)

Workflow:

Here is a resource on 

Regex tool parse mode : https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415

Hope this helps 🙂

[jdunkerley79]

For an alternative to regular expressions (as they can be complicated), you could use the Text to Columns tool.

Based on your data splitting on Space would work.

[markosxman]

Thanks that worked perfectly