BUG: Escape characters missing in the CSV export file
Currently, if a student's name contains a double quote character, the CSV file from the Data Export Scheduler does not properly escape the character causing issues with opening/displaying the data file.
Example:
(currently) ,"James "Jr"",
(correct escaping) ,"James ""Jr""",
In a CSV, double quote characters should be prefixed with an additional double quote character.
Link to RFC rule:
https://datatracker.ietf.org/doc/html/rfc4180#:~:text=zzz%2Cyyy%2Cxxx-,7.,-If%20double%2Dquotes
4
votes
Bucky Bush
shared this idea