Save CSV file as Pipe delimited text file

G

germantim

Hi,

my boss send me a mail with 5 csv files and wants me to load them as a
pipe delimited text file to our IT department. Since the whole IT
department is already at home and I have to do it this evening, I hope
to find some help here.
Thank you very much in advance!!

Kind regards

Tim:)
 
D

Dave Peterson

If you're lucky, you could open each CSV file in Notepad and do
edit|replace
what: , (comma)
with: | (pipe)
replace all

But this will change any field that has embedded commas, too.

====
If that is a problem, then I would open the .csv files in excel
(and copy|paste to merge them into one worksheet--not sure about that)

Then change my windows regional settings (in the control panel) list separator
from a comma to a pipe.

Then file|saveas as a .csv file

Open the file in Notepad to verify it.

And change my list separator back to a comma.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV Tab Delimited 4
I want to save an Excel file in "Pipe Delimited" (instead of csv). 3
Converting Excel file to text delimited file 3
Export Access Query to a pipe delimited .csv file 5
Import Text file with Pipe Delimited - 2007 4
*.csv format change if .xlt save as .csv in Excel 2007 1
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1
Adding a new file extension for Pipe Delimited files 3

Top