double pipe delimiter

[conn77]

I need to import a large file with double - pipe delimiter e.g. ||

Does anyone know a way to do this? Possibly via vba?

Thanks in advance for any suggestions!

 

[plog]

Sure it's possible with VBA, but if this is a one time deal, just use the wizard.

External Data->Text File
Select your file and click 'Ok'
Choose Delmited in the top and click 'Next'
At the top, choose 'Other' and type in double pipes

 

[plog]

Scrap that, sorry. You can only use 1 character for a delimiter. New suggestion--do a find/Replace in your file and replace the double pipes with a character not found in your data. Possible a single pipe(|), a squiggle (~), ampersand (&) or some other non-common character that isn't found in your file.

 

[gemma-the-husky]

import using a single pipe to a new table

you will get a load of extra "dummy" blank fields between each pair of || characters which you can discard.


plog's idea - search and replace in the text file is a good idea, too.