Richard Bucker

Processing CSV Files

Posted at — Aug 18, 2022

Processing CSV files whether they are actually comma or tab separated is a pain in the ass. The problem is that any jackle just dumps a spreadsheet and calls it great but in fact it is just the beginning.

Traditionally CSV files were meant to be formatted with some standards or at the very least some best practices. In the last few days it has been a parsing mess. I decided to use some advanced AWK and it worked nicely.