csvfix - Parse CSV files

This utility provides the ability to parse text files in which the values/columns are delimited by commas, or a delimiter of your choice. Because of the possibility that CSV files contain multi-line data (and, oh, the lack of a standard that will foil even the most skilled greppers), it is recommended that you use CSVFix when dealing with delimited-text data.

The list of subcommands is long; if you need to do something specific, check the CSVFix docs and you’ll probably find what you need.

To install on corn.stanford.edu, after having set your PATH to include ~/compciv_bin:

wget https://bitbucket.org/neilb/csvfix/get/version-1.6.zip unzip version-1.6.zip && rm version-1.6.zip cd neilb-csvfix-e804a794d175 make lin cp ./csvfix/bin/csvfix ~/bin_compciv/

For the purpose of some of the examples, example.csv contains the following: