27 Jul
2011
27 Jul
'11
1:38 a.m.
Nicole C. Engard schreef op di 26-07-2011 om 14:22 [-0400]:
If an order contained a note with a newline in it, that line would come out as a blank entry in the exported CSV. This patch strips such characters, globally.
It should be OK to have \r and \n in CSVs, provided the fields are correctly wrapped in a quote characters, and any internal quote characters are correctly escaped (let me regale you with my tales of dealing with malformed CSV files coming from other ILS systems...another time perhaps.) I would expect Text::CSV to be able to understand such quoting and escaping properly. Also, keep in mind that some spreadsheet systems can't handle newlines in CSV files, while others can. IME, LibreOffice can, gnumeric can't. Robin.