georgehotelling··on CSVfix is a tool for manipulating CSV dataI've had some success cleaning up CSV data in the past using OpenRefine[0] (née Google Refine, and Freebase Gridworks before that). It is a really powerful tool for getting data in a consistent format.[0] http://openrefine.org/