From: John Mcleod Date: 2009-11-18T06:12:18+09:00 Subject: using FasterCSV to clean CSV file Hello all, I was wondering, can FasterCSV be used to clean a csv file of unwanted characters, endline spaces, tab spaces and other characters? I have a csv file 6,000 lines long and it comes from another department. I have been working to read this file into a database via FasterCSV. Went I start to read the file in, I get the dreaded "FasterCSV::MalformedCSVError" error message. I've worked with this in the past and the solution was to "clean" the data. EOL spaces and other undesired characters were scattered within the file. Is it possible to use FasterCSV for this task? JohnM -- Posted via http://www.ruby-forum.com/.