CSV file - more then one character as seperator

[rancohen_2000]

Hi,

I know how to import text file with one character as spererator (like comma or space)

But how can I import text file with more then one chracter as seperator?

for example if there are two spaces or space and comma?

Thanks...

[rebelxt]

If it's just a one-time thing, edit the file, changing the multiple characters to singles. Save the file with another name so you don't lose the original. You don't even have to keep the modified file after the import.

[rancohen_2000]

Thanks rebelxt,

But i need to do it all the time

[rebelxt]

The 'Text Import' dialog has a 'Merge delimiters' check box. Click on the help button in that dialog. That may be what you need.