how do you parse comma-separated-values (csv) with awk?
Use a tool that you do know:)
That awk script does not look it deals with " and other CSV oddities. (I think it just splits on tabs - as the other answers note it needs to be change to split on , ) python, perl .Net etc have objects to fully deal with CSV and XML and probably you could write the solution in as few characters as the awk script and MORE importantly understand it.
Remember that splitting by comma in a csv is fine until you get the following scenario:
1997,Ford,E350,"Super, luxurious truck"In which case it will split "Super, luxurious truck" into two items which is incorrect. I would recommend using the csv libs in another language as 'Mark' states in the above post.