Saving txt files with quotation mark delimiters

S

slipstrm

I have a fixed width data file and need to convert it to a csv file with
quotation marks and commas a delimiters. I thought there was an easy way to
do this in Excel. I open the file with excel and I can define fields but I
cant figure out a way to save the data with quotation marks around the files
separated by commas. Is there any easy way to do this. I have 8 files to
do this with containing about 20-25K records each.

Thanks
 

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

Changing commas in .csv to quotation marks 1
Inability to add quotation mark around a variable by concatenation in VBA 4
Hidden Formating Or Delimiters: Showing Of ? 2
How to keep loaded file's format intact? 1
problem with automatic quotation marks 1
Single Quotation mark in CSV 1
excel save as csv quotation mark 1
Converting Numbers from Excel to TXT files 2

Top