Which delimiter to use to split columns if I import this file with no delimiter

[Data_Alter]

I have to import it as fixed width as I get the error Missing a closing quote for a record when I use Tab delimiter

[FrederikE]

Hey @Data_Alter,

You should be able to import it with fixed width (but set the length to an extremely high number (just to avoid issues)) and then use a "Text To Columns" Tool to split it. There you should be able to use - " - if this doesn't work try copying the delimiter from the file itself. 

[flying008]

Hi, @Data_Alter 

1- Which type of you file ? txt or dat ?  can you upload some sample data ?

2- you can import file as one field have enough length with no delimiter.

3- use regex_replace() formula to replace all ">**>" as "|" .

4- then you can use tool 'text to columns' by delimiter '|' to split the field.