I've got a two column CSV with a name and a number. Some people's name use commas, for example "
Joe Blow, CFA." This comma breaks the CSV format, since it's interpreted as a new column.
I've read up and the most common prescription seems to be replacing that character, or replacing the delimiter, with a new value (e.g.
…