c2c-oerpscenario team mailing list archive

[Nick White <816348@xxxxxxxxxxxxxxxxxx>]

This is documented here, by the way:
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#FileFormat

> Fields that contain double quote characters must be surounded by double-quotes, and
> the embedded double-quotes must each be represented by a pair of consecutive
> double quotes.
> So, John "Da Man" Doe would convert to "John ""Da Man""",Doe, 120 any st.,...

Wikipedia acknowledges using \ to escape, but says that only "some
implementations" do it, rather than "many implementations" which use
double-quoting.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/816348

Title:
  CSV should escape using double-quotes

Status in Qt/KDE OpenObject Client:
  New

Bug description:
  When exporting data and you can get CSV output by choosing "Save as
  CSV". However, if one of the fields exported has double quotes, they
  are escaped with a backslash, so

  Product 10" becomes Product 10\"

  However, CSVs should escape double-quotes using a quote, so the above
  example would read Product 10""

  Otherwise, openoffice (at least) screws up with CSVs with quotes.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-client-kde/+bug/816348/+subscriptions