Reading Data

Question

Hello all, I have a CSV file that has no delimiters, all data in one tab with no delimiters.

Is there any text to column formula that i can parse the data in separate fields?

Thanks in advance.

JagdeeshN · Answer

@AbdullahMansour90

Without any delimiters the best way to do it is using RegEx.

Please find a discussion below on the same topic:-

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-convert-CSV-file-without-any-delimiters-to-a-usable/td-p/497106

Best,

Jagdeesh

AngelosPachis · Answer

Hi @AbdullahMansour90 ,

When importing the csv, you can type

to use tab as a delimiter and parse the data on import. You can do that in the configuration window of the input tool.

EDIT : Correction on that, I thought that the tab was the delimiter, ignore my response above

Angelos