CSV is pretty poorly standardized, but if you're going by RFC-4180, Numbers is d... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		chc on June 8, 2017 \| parent \| context \| favorite \| on: Show HN: Npm module that makes easy to convert JSO... CSV is pretty poorly standardized, but if you're going by RFC-4180, Numbers is definitely right, due to the interaction of two rules: * double quotes aren't allowed inside a field that isn't double-quoted * double-quotes that do appear in a field have to be escaped by preceding them with another double quote. So by RFC-4180, I'm pretty sure ""hehe"" shouldn't be possible, and the way to represent "hehe" with the quotes is """hehe""".

codezero on June 8, 2017 [–]

Cool, yep, thanks for pointing out the RFC. I don't envy anyone making CSV parsers and basically assume they won't work when I need to use them :)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact