Simon Willison’s Weblog

12th December 2020

TIL Skipping CSV rows with odd numbers of quotes using ripgrep — I'm working with several huge CSV files - over 5 million rows total - and I ran into a problem: it turned out there were a few lines in those files that imported incorrectly because they were not correctly escaped.

Posted 12th December 2020 at 3:50 am

Recent articles

Adding TILs, releases, museums, tools and research to my blog - 20th February 2026
Two new Showboat tools: Chartroom and datasette-showboat - 17th February 2026
Deep Blue - 15th February 2026

This is a beat by Simon Willison, posted on 12th December 2020.

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe