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.
I 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.
3 comments
[ 0.24 ms ] story [ 19.5 ms ] thread