Hello,
Everyday we generate daily reports in Excel 2000 and then save them as .csv files. These .csv files are then re-named to .txt files because our partner requires these files to be .txt files but still maintain the comma separated fields. Re-naming the .csv files to .txt does not appear to be a problem.
The problem we are having is that each comma separated field must also be encased in double quotes in the .txt file. I am having difficulty in finding an automated way to produce these double quotes in the .txt file. I can not go through the file and add them manually as these files are huge, approx 160K+ lines. The files are so big that I have to split them up into at least two files because of Excel 2000's line limit (anyway around that?).
For example, this is how one row of the .txt file would look when done properly. Note that each comma separated field has double quotes inside them, even the empty fields.
"08/08/2006 12:00AM to 11:59PM","XYZ Inc","123456","Store #3456","1","DURHAM","NC","20060808","21:17:29","000034567"," ","123456"
Please note that these are not my requirements but rather our partner's so I have no flexibility there. Ideally I think it would be best if this could be done from Excel but perhaps there is another answer.
Does anyone know of a simple method for accomplishing this? If so, please let me know. That would be most appreciated!
Thanks!
Steve
Everyday we generate daily reports in Excel 2000 and then save them as .csv files. These .csv files are then re-named to .txt files because our partner requires these files to be .txt files but still maintain the comma separated fields. Re-naming the .csv files to .txt does not appear to be a problem.
The problem we are having is that each comma separated field must also be encased in double quotes in the .txt file. I am having difficulty in finding an automated way to produce these double quotes in the .txt file. I can not go through the file and add them manually as these files are huge, approx 160K+ lines. The files are so big that I have to split them up into at least two files because of Excel 2000's line limit (anyway around that?).
For example, this is how one row of the .txt file would look when done properly. Note that each comma separated field has double quotes inside them, even the empty fields.
"08/08/2006 12:00AM to 11:59PM","XYZ Inc","123456","Store #3456","1","DURHAM","NC","20060808","21:17:29","000034567"," ","123456"
Please note that these are not my requirements but rather our partner's so I have no flexibility there. Ideally I think it would be best if this could be done from Excel but perhaps there is another answer.
Does anyone know of a simple method for accomplishing this? If so, please let me know. That would be most appreciated!
Thanks!
Steve