a customer uses Excel and after some trouble we found out now that there are problems when a CSV export is imported to Excel: line breaks within these textarea fields lead to a break in import as if there were a new data line. The csv has the "*" as a seperator and the " for text identifier. In the exports cck fields are exported and those of type textarea make the trouble. They use the latest Excel version as I know.

My only way to solve this problem was to strip all line breaks by a custom views php field.



sylvain_a’s picture

Please note that you can open the CSV file in OpenOffice and get a proper rendering.