Done this with massive log files. Used perl and regex. That’s basically what the language was built for.

But with CSVs? I’d throw them in a db with an index.