Hi,
I ran into the same problem - especially with long answers - and solved it by patching the according export routine.
You will find this one in \application\helpers\admin\export\CsvWriter.php
The very last function in this file (line 104ff) is
Code:
protected function csvEscape($value)
{
return CSVEscape($value);
}
For my purposes I added as follows:
Code:
protected function csvEscape($value)
{
$value = str_replace("\r\n", "; ", $value); // cr & new line
$value = str_replace("\n", "; ", $value); // new line
$value = str_replace("\r", "; ", $value); // cr
return CSVEscape($value);
}
You may like to add two slashes '//' in front of those of the 3 lines beginning with '$value=' you do not need.
