torn-userscripts icon indicating copy to clipboard operation
torn-userscripts copied to clipboard

CSV is not valid when the message includes quotes

Open mirod opened this issue 4 years ago • 0 comments

Quotes are not escaped within the message.

So the CSV includes lines like this:

"Tue, 29 Dec 2020 08:04:57 GMT",Faction,"You gave $21,000,000 to <a href = "/profiles.php?XID=2352782" target = "_self">MacB</a> from <a href = "/factions.php?step=profile&ID=27223"target = "_self">Little Stompers</a>"

my CSV parser complains that this is not proper CSV, due to the quotes in the message.

To avoid the problem, I would replace cvs by tsv and be done with it.

mirod avatar Dec 29 '20 13:12 mirod