If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Saving txt files with quotation mark delimiters
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 |
#2
|
|||
|
|||
Saving txt files with quotation mark delimiters
See http://support.microsoft.com/kb/291296 for a macro...
"slipstrm" wrote: 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 |
#3
|
|||
|
|||
Saving txt files with quotation mark delimiters
Thank you sheeloo.
"Sheeloo" wrote: See http://support.microsoft.com/kb/291296 for a macro... "slipstrm" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|