[Koha-devel] [Koha-patches] [PATCH] [SIGNED-OFF] Bug 6614: Remove newlines from order notes when exporting to CSV

[Robin Sheat]

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: </pipermail/koha-devel/attachments/20110727/608e213d/attachment.pgp>