23 ms·
They could have tilted the example even more in their favor by using csvs that had a delimiter inside the string (“Smith, John”). Or quoted new lines. That’s an
by 0cf8612b2e1e 2y ago
They could have tilted the example even more in their favor by using csvs that had a delimiter inside the string (“Smith, John”). Or quoted new lines. That’s an “edge case” where I know I cannot lean on cli tooling and need to use a real language.
- wenc 2y agoI think they were trying to keep the examples simple but you’re right. Parsing CSV is a mess — DuckDB does a decent job at it with its CSV sniffer but most CSV tooling have a ton of switches for corner cases.