3 ms·
To your point it's hard to see how the referenced article qualifies as a standard. It does not deal with escape characters or missing values, two places where
by hodgesrm 8y ago
To your point it's hard to see how the referenced article qualifies as a standard. It does not deal with escape characters or missing values, two places where CSV implementations tend to vary in random ways.
- Lazare 8y agoMy comment may have been unclear, but I agree with this completely.
- wlesieutre 8y agoI've recently been dealing with some CSV data exported from Excel. One of the columns has lengths measured in inches or feet. A column that says 14" exports as , '"14"""', It feels downright silly to me.
- deathanatos 8y agoA cell w/ 14" would be ,"14""", And I verified that all four of Excel's CSV varieties write this, but this is also what RFC CSV writers would emit. Not saying you can't pick up oddities elsewhere, but as stated, it's not that bad. (Not that I condone use of CSV… it's an awful format.)
- wlesieutre 8y agoAh you're right, the spot I was looking at was after having read it into Python and split into a list on the commas, so the outer ' is my string container. Whoops.