Use Gawk to process CSV files
Awk and Gawk are very powerful tools to process text files. Yet, CSV files are especially difficult to process. Fields are separated by comma or semicolon, depending on the country. These separators can also be used in a field inside double quotes. Which makes it very difficult for Awk to split a line into fields. Moreover, a field with double quotes can contain line breaks, which makes it difficult for Awk to process it.