import text file with two delimiters

https://fmforums.com/topic/63513-import-text-file-with-two-delimiters/
Followers

November 20, 200817 yr

Newbies

I have some very large data files that use a mix of delimiters - generally they look like this:

Field1/tField2/tField3;Field4;Field5

where "/t"(aka tab) and ";" are the delimiters.

with smaller files I could just import them into excel (which allows me to choose multiple delimiter) and export them out. But there are too many entries in these files.

I'd be very grateful for any pointers on how to import such a file.

November 20, 200817 yr

Two options:

1. Pre-process the files in a text editor, replacing the semi-colons with tabs;

2. Import the files "as is" and break out the last field into two. You could do this during the import by using auto-entered calculations, or after the fact.