Text to column help

crtakacs

I can't seem to get the results I'd expect. I just want to separate the data in the DownloadData column. For example in row 2, I am trying to get separate columns for "CUSR0000SA0", "1997", "M01", and "159.4" with the corresponding header for each. Can someone assist? 

Aidan_K

Hi @crtakacs ,

Have you tried 'Tab' as your delimiter, hard to say for sure but it appears that your data is tab delimited.

tab delimited is:-

\t

here is some more info on it - https://help.alteryx.com/current/designer/text-columns-tool

regards,

Aidan