- Posts: 1
- Thank you received: 0
End of Line Character
- moot_systems
-
Topic Author
- Offline
- Fresh Lemon
-
Less
More
1 year 1 month ago #158616
by moot_systems
moot_systems created the topic: End of Line Character
Doing a download of survey responses to CSV, find that the end of line character is LF.
Have recently upgrade to 2.67.3 +170728 - on Linux
Previously I believe that end of line in the output CSV file was CR LF.
The issue with the change is that long responses themselves contain LF - so difficult to parse the files.
Have recently upgrade to 2.67.3 +170728 - on Linux
Previously I believe that end of line in the output CSV file was CR LF.
The issue with the change is that long responses themselves contain LF - so difficult to parse the files.
Please Log in or Create an account to join the conversation.
11 months 1 week ago #160578
by orvil
Best regards/Beste Grüße,
O. Villani
orvil replied the topic: End of Line Character
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
For my purposes I added as follows:
You may like to add two slashes '//' in front of those of the 3 lines beginning with '$value=' you do not need.
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
protected function csvEscape($value)
{
return CSVEscape($value);
}For my purposes I added as follows:
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.
Best regards/Beste Grüße,
O. Villani
Please Log in or Create an account to join the conversation.