import text file with two delimiters

[ori]

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

Field1/tField2/tField3;Field4;Field5

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.

[comment]

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.