Re^5: Text::CSV_XS and "binary" mode

The default separation character is a comma, the default quotation character is a double quote (").

If the quotation character appears inside a field, it ought to be escaped with the escape character, which by default is also a double quote.

Separation characters can only appear inside a field if the complete field is quoted. In that case, the separation character should not be escaped.

For the two lines of CSV that you posted, I see no problem at all for the default values when using binary => 1 (except of course for the funny typo).

Enjoy, Have FUN! H.Merijn

Comment on Re^5: Text::CSV_XS and "binary" mode Download Code

Replies are listed 'Best First'.
Re^6: Text::CSV_XS and "binary" mode by bittis (Sexton) on Jan 26, 2009 at 11:36 UTC
Ah i see, in other words if a field is to include a comma or carriage return that field should be double quoted, i will have a look at the export options and see if i can have some of the fields quoted	[reply]
Re^7: Text::CSV_XS and "binary" mode by Tux (Canon) on Jan 26, 2009 at 13:22 UTC
BINGO! :) Enjoy, Have FUN! H.Merijn	[reply]