Awk is one of those tools I learned how to use very recently. It is now my go-to tool for reformatting all sorts of things into SQL queries, code snippets etc.
I would encourage people to look at this article and dig into Awk, especially if operations are a part of your job description.
I’ve used awk in small capacities for ~15 years now, but I only recently realised it has associative arrays as a datatype. Awk is far more capable than I dumbly assumed all those years ago.This is a fine intro, and if you’re like me and have always just cobbled together a few quick & dirty awk scripts you might be surprised if you dig a little deeper.