Oh, I've used some awk too. My favorite (and most ridiculous) application was using the qawk from The AWK Programming Language[0] book to make a flat-file relational database of CSV files. Ultimately I just moved to sqlite but I learned a lot about awk in the process!
0: https://ia800708.us.archive.org/25/items/pdfy-MgN0H1joIoDVoI...