From: Marnen Laibow-Koser <marnen@...>
Date: 2009-11-18T07:01:47+09:00
Subject: Re: using FasterCSV to clean CSV file

John Mcleod wrote:
> 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 wouldn't trust any Microsoft program to produce valid data in any 
interchange format.

> I understand that there are several different formats (MS-DOS, Windows, 
> MAC) when considering saving a CSV. Which one should be chosen?
>

Those have to do with text encodings and line breaks.  They're probably 
beside the point.  (And you mean "Mac", not "MAC" [= Media Access 
Card].)
> John

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
marnen@marnen.org
-- 
Posted via http://www.ruby-forum.com/.