Export TO CVS bug

Comments

• thenicespider

  January 2006 edited 7:13PM

  valos wrote:

  2  string3  stri"ng4
  
  but it should look like:
  
  "2","string3","stri""ng4"

  If you have:
  2 string3 stri"ng4
  
  then the result using MS Excel is:
  2,string3,"stri""ng4"
  
  What show above is there is no double quote (") for: 2 and string3.
  This what CSV (Comma Separated Value) means in Excel.
  
  BUT, how does SQL Server 2K handling CSV?
  The CSV created by SQL Server 2K is:
  2,string3,stri"ng4
  
  Interested?
  
• valos

  January 2006 edited 7:13PM

  I don't know what is the relevance of SQL Server 2K here or how it handles CSV.
  
  The following CSV formats:
  
  2,string3,"stri""ng4"
  
  and
  
  "2","string3","stri""ng4"
  
  ARE BOTH VALID and accepted by MS Excel.
  
  What I wanted to highlight here is a bug in CSV export because it doesn't escape double quotes.
• valos

  January 2006 edited 7:13PM

  Hi,
  
  Can somebody from FastReport team confirm wheter or not this is a bug in their opinion and if this will be fixed or not in the next FR3 release please?
  
  Many thanks,
  Vasile