Advertisement

01.16.2007 at 07:34PM PST, ID: 22125255
[x]
Attachment Details

Export CSV. Preserve Text Qualifiers.

Asked by Bob-Villa in Software Office Suites, Microsoft Office Suite, Microsoft Excel Spreadsheet Software

Tags: csv, text, excel, qualifier, export

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
[+][-]01.16.2007 at 08:36PM PST, ID: 18329963

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Software Office Suites, Microsoft Office Suite, Microsoft Excel Spreadsheet Software
Tags: csv, text, excel, qualifier, export
Sign Up Now!
Solution Provided By: zorvek
Participating Experts: 3
Solution Grade: A
 
 
[+][-]01.17.2007 at 07:15AM PST, ID: 18332693

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.17.2007 at 07:22PM PST, ID: 18338030

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.08.2007 at 03:04PM PDT, ID: 19245990

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.13.2007 at 07:57PM PDT, ID: 19280196

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32