CSV export can fail on value containing double-quotes

Double quotes are not escaped so e.g. "thisstringincquotes" will lose its quotes when imported by e.g. Excel.

Workaround: recode.

I'll happily incorporate any fix you can provide that covers any types of quotes that can be reinterpreted by Excel. I've also noticed that some versions of Excel produce different results between opening a file via double click or from the file menu. Using import is another thing.

Until then, I'll mark this as [LP]

I'll happily incorporate any fix you can provide that covers any types of quotes that can be reinterpreted by Excel.

I don't know what Excel reinterprets and the problem I'm reporting is not specific to Excel. I think it deserves fixing regardless.

I suggest for all text fields:
"$replace(%title%,","")";

Agreed.

Yes, doubling of quote characters within a string field is standard CSV convention.

DD.20091127.1333.CET