csv export not valid for excel

I have searched the forums for csv export and have not been able to find a way to export the query results in "standard" csv format that Excel can handle. Any idea how to save the following result in a csv file quoting with double quotes: select 'this is a test of a comma, a ", and a ''' test from dual; Excel escapes the double quotes with another double quote.

Yes, I have tried that. When using double quotes, they don't escape the double quote inside the string: "this is a test of a comma, a ", and a '" With ansi, they correctly escape the single quote with an extra single quote: 'this is a test of a comma, a ", and a ''' However, excel doesn't support the ansi format. If they made double quote work like ansi (escape any double quotes with an extra double quote): "this is a test of a comma, a "", and a '" Then it would be perfect.

It should go into a single cell preserving all quotes. I use Excel 2004 for Mac and Excel 2002 for Windows; both treat the csv files the same way. If the cell is encoded as: "this is a test of a comma, a "", and a '", it will be treated as a single cell. Excel double quotes any cell that contains a comma, double quote, or whitespace that causes a cell be multiple lines (like a newline character). When the cell contains a double quote, it escapes any internal double quote with another double quote. If the text data is quoted with double quotes and any internal double quotes are replaced with two double quotes, then excel will be able read it just fine.

Our data contains tab, space, comma, newline, single quote, and double quote characters; so double quoting the text is necessary.

This is no problem of DBVis but of Excel (or the way you import the csv). If i set quoting style to ANSI for the export and set the text recognition char (or what ever it is called in english, in german it is "Texterkennungszeichen" and is a dropdownlist with ' and " and {none} as values) to the single quote ', then everything is fine. If Excel did not offer you the import assistent on opening the file, save it as *.txt. BTW: newline in data is a real headache for csv... and i don't know wether there is any way import this correct, because newline is the seperator for rows. Hope, this helps :-) Bye, Peter

I am having the same problem. It is not an Excel problem, I cannot import the file to other applications. The csv file that is created does not comply with CSV standards. CSV standards: Embedded double-quotes - Embedded double-quote characters must be doubled, and the field must be delimited with double-quotes. Embedded line-breaks - Fields must be surounded by double-quotes. Always Delimiting - Fields may always be delimited with double quotes, the delimiters will be parsed and discarded by the reading applications. Here are my export settings: format="csv" CsvColumnDelimiter = "," CsvRowDelimiter = "\r\n" QuoteTextData = "Double" My text data also contains new lines, so the field is surrounded by double quotes. If the data also contains a quote it must be translated to "". The workaround for now is to replace " with "" in your select statement on the fields that cause problems. I am hoping DBVisualizer will realize this as a problem and fix soon. Jim

Excellent! I wish I would have checked back sooner. After some basic testing, it seems to be functioning as expected in the new version.