From: John Mcleod Date: 2009-11-18T06:46:47+09:00 Subject: Re: using FasterCSV to clean CSV file Thanks for the reply James. I have read and imported into DB simple CSV data in the past and never had problems like this file. >FasterCSV does need valid CSV data, yes. If you have non-valid CSV >data, it will need to be cleaned before FasterCSV can read it. The question of validity is confusing. When a file is saved via MS-Excel isn't it valid? I understand that there are several different formats (MS-DOS, Windows, MAC) when considering saving a CSV. Which one should be chosen? John -- Posted via http://www.ruby-forum.com/.