Reading Data

[AbdullahMansour90]

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.  

[AngelosPachis]

Hi @AbdullahMansour90 ,

When importing the csv, you can type 

\t

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

[JagdeeshN]

@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-de...

Best,

Jagdeesh