IBAUCLAPlaya
Board Regular
- Joined
- Dec 17, 2007
- Messages
- 99
I have a CSV file that is outputted from our internal system. See below for example of what it looks like when opened in notepad:
When I open this in excel and modify a few cells/rows, then resave as CSV, it the quotes no longer show up around the field when opened in notepad. In order for the CSV file to function (uploading into system), it needs to have the quotes around the fields.
How do I get excel to save as a CSV and keep the quote marks around each cell?
Code:
"H","A1847","11155131K","C9025","1041303334","OTHER",3,"","11/24/2009",29,"","","OH",2,350,"","N"
"D","A1847","11155131K","C9025",1,"102213",1,125,"11/24/2009","11/24/2009","","","","Property Rekey Fee","N",,"Y"
"D","A1847","11155131K","C9025",2,"102822",3,75,"11/24/2009","11/24/2009","","","","Installed Smoke Detector","N",,"Y"
"H","A1847","11155139K","C9025","1041595171","OTHER",3,"","11/24/2009",29,"","","LA",1,135,"","N"
"D","A1847","11155139K","C9025",1,"102412",1,135,"10/02/2009","11/03/2009","","","","Winterized - Dry System","N",,"Y"
"H","A1847","11155143K","C9025","1041800394","OTHER",3,"","11/24/2009",29,"","","PA",1,250,"","N"
"D","A1847","11155143K","C9025",1,"102899",1,250,"11/13/2009","11/19/2009","","","","Eviction 5 Men/2 Hours @ $25","N",,"Y"
"H","A1847","11155149K","C9025","1065015039","OTHER",3,"","11/24/2009",29,"","","LA",2,775,"","N"
"D","A1847","11155149K","C9025",1,"102811",1,500,"10/09/2009","11/04/2009","","","","Removed damaged carpets","N",,"Y"
"D","A1847","11155149K","C9025",2,"102811",1,275,"10/09/2009","11/04/2009","","","","Removed rotted flooring","N",,"Y"
When I open this in excel and modify a few cells/rows, then resave as CSV, it the quotes no longer show up around the field when opened in notepad. In order for the CSV file to function (uploading into system), it needs to have the quotes around the fields.
How do I get excel to save as a CSV and keep the quote marks around each cell?