title: How to pre-process CSV data for FasterCSV?
body: <p>We're having a significant number of problems creating a bulk upload function for our little app.  We're using the FasterCSV gem to upload data to a MySQL database but he Faster CSV is so twitchy and precise in its requirements that it constantly breaks with malformed CSV errors and time out errors.</p>
  
  <p>The csv files are generally created by users' pasting text from their web sites or from Microsoft Word docs so it is not reasonable to expect that there will never be odd characters like smart quotes or accents in the data.  Also users aren't going to be readily able to identify whether their data is perfect enough for FasterCSV or not.  We need to find a way to fix it for them automatically.</p>
  
  <p>Is there a good way or a reliable tool for pre-processing CSV data to fix any nits in the data before having the FasterCSV gem process it?</p>