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.)

Venkatesh V wrote:

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

--

Dave Peterson