I have a CSV file. It is comma separated with " as the text qualifier. The text qualifier exists weather the field has data or not.
"A","B","","D","E"
When I save via Excel as CSV I loose all " qualifiers except for fields that contain quotes or commas
When I save using OpenOffice Spreadsheet as CSV I get " qualifiers for everything but blank fiels which are just commas.
I have tried some other solutions but I need this to be easy for an end user. Basically I need a user to open a csv, add a column or 2 and save the file while preserving the original qualifier and separator.
Start Free Trial