How to create '|' separated file

[Guest]

HI,
Creation of CSV file is simple.
Just 'Save As.." the excel file and it will be saved as a '|' separated.

But, how to create a '|' separated file?

Note: I wouldnt like to create csv and then replace all commas ',' with '|'.
This is because in between the text there may be some commas.


Thanks a Lot,
Venk

 

[Guest]

When click FILE in the menu and selects SAVE AS, one of the options in the
SAVE AS TYPE combo box is "CSV (Comman Delimited)(*.CSV)".

This option will do exactly what you're wanting to do.

 

[Guest]

Sorry about my previous reply Venkatesh, i gave you the answer that you
already have. Not enough coffee this morning.

I don't know of a method, apart from concatenating all of the data, that
will let you change the delimiter to a pipe "|" character.

If you have Access available you can link or import your worksheet into
Access and then export the data as a text file. This will start the export
wizard in Access and you can specify your delimiter there.

 

[Dave Peterson]

What happens if you temporarily change the windows list character from a comma
to a vertical bar?

windows start button|settings|control panel|Regional settings applet
(or regional and language options)

Click the customize button
Numbers Tab
List separator

(I'd change it back when I was done.)

 

[Guest]

Thanks a lot.

It did work

What happens if you temporarily change the windows list character from a comma
to a vertical bar?

windows start button|settings|control panel|Regional settings applet
(or regional and language options)

Click the customize button
Numbers Tab
List separator

(I'd change it back when I was done.)