topic Re: Splitting a string with no delimiter and non-formatted data in Alteryx Designer Desktop Discussions

Splitting a string with no delimiter and non-formatted data

billbillz — Mon, 19 Feb 2024 15:08:56 GMT

Hi all,

I need to separate some data into number and description however the data is extremely unformatted making it hard to use text to column.

Heres an example of the types of data:

Cat food 5005

6003 - Dog Food

Hamster Food - 9002

Big dog food 2002

S.A chinchilla food 2030

If anyone has ideas of how to split this so example

column 1- 5005 then another column with Cat food

Hope that makes sense!

Thanks in advance

Re: Splitting a string with no delimiter and non-formatted data

aatalai — Mon, 19 Feb 2024 15:12:46 GMT

create two columns with the same data (use the formula tool). Then 2 data celanese one for each column, one to remove numbers and one to remove letter (also adjust for puncations and things accordingly in the data celanese settings.

Re: Splitting a string with no delimiter and non-formatted data

MilindG — Mon, 19 Feb 2024 15:17:11 GMT

@billbillz Regex should work.