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 · Accepted solution]

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

[JagdeeshN]

@crtakacs 

You can use a combination of RegEx, TextToColumns and Dynamic Rename to do what you described.

Please find attached a sample workflow showcasing the same.

Do let me know if this works for you.

Best,

Jagdeesh Narayanan