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