https://news.ycombinator.com/item?id=28708145
...but if your files are CSV, there is a CSV extension for gawk
@include "csv" BEGIN { CSVMODE = 1 }
It's funny searches for awk CSV seem to yield a bunch of SO questions where the answers are increasingly cumbersome regexes instead of this extension.
Of course, you can't count of this extension being widely installed, but it's great for my own desktop.
https://news.ycombinator.com/item?id=28708145
...but if your files are CSV, there is a CSV extension for gawk