We often hear that we should use the right tool for the right job. The problem for developers is becoming aware of those different tools. So I want to save you some time and introduce you to an old tool that is good for simple processing of CSV files. The language is so simple that an experienced programmer can pick it up in an afternoon.
Awk is a text processing utility that happens to be a programming language. It was created back in the 70s by Aho, Weinberger, and Kerningham, hence its name. Awk was probably most popular during the 80s until Perl, strongly inspired by Awk, replaced it.
So is Awk obsolete? It is obsolete as a general purpose language. But when used for text processing, such as when we work with CSV files, it is good tool to have around.