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.
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:
Proposed changes to /core/DataTable/Renderer/Csv.php:
Proposed test cases added to /tests/core/DataTable/Renderer.test.php:
(In ) - fixed #609 Misaligned data when exported in CSV
thanks vipsoft for your pre-analysis and suggestions