manipulating csv files...

A colleague used Unix to manipulate a csv file.
It was very large so importing it into R or opening in Excel would have causes some problems.

the command used was

• cut - http://stackoverflow.com/questions/7857090/awk-extract-specific-columns-from-delimited-file

perl was also used directly from the unix prompt to remove everything starting with a hash tag #

Useful addition to the data munging world!