title: How to test a CSV file and how to find difference between two CSV files
body: <p>I would like to know if is there any way of testing a CSV file before importing to database?</p>
  
  <p>I have a huge CSV file with multiple columns and each column has different datatype and size. How can I test that the data appearing in generated CSV file is in accordance to the size of each column?</p>
  
  <p>Also, Is there any way to compare to similar CSV File and printing the difference between those two files? 
  I tried CSV Diff on Windows7 and it's not working.
  <a href="http://sourceforge.net/projects/csvdiff/" rel="nofollow">http://sourceforge.net/projects/csvdiff/</a></p>
  
  <p>tabletext comparator(<a href="http://www.nirsoft.net/utils/csv_file_comparison.html" rel="nofollow">http://www.nirsoft.net/utils/csv_file_comparison.html</a>) looks like a viable option but failing to compare very huge files</p>
  
  <p>Any programming option or script that can help me in dealing with my current concern.</p>