I am downloading data from piwik using API and in csv format. However, at certain places, e.g. row 42, 56, 66 in attached file, the data is shifted to undesired columns stopping me from processing. Keywords: csv
Sorry, my bad. The data set contains commas, reason enough for misalignment.
This is one of the better write ups on the CSV pseudo-standard: - http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm
Proposed changes to /core/DataTable/Renderer/Csv.php: - escape double quotes (" becomes "") - wrap any field with double quotes if it contains comma or double quotes
Proposed test cases added to /tests/core/DataTable/Renderer.test.php: - field with no double quotes or commas - field with comma - field with double quotes - field with commas and double quotes
(In ) - fixed #609 Misaligned data when exported in CSV thanks vipsoft for your pre-analysis and suggestions