From: Adam Sanderson <netghost@...>
Date: 2005-11-25T02:42:27+09:00
Subject: Re: Parsing excel CVS data on a mac OSX to extract blocks of cells

I've had a similar problem.  It sounds like you used Excel somewhere.
My experience has been that Excel for the mac likes to save CSV files
with MacOS 9 line endings which Ruby doesn't like.  In the future, you
can choose 'Windows CSV' or something to that extent.  It's really
silly, but it works.

Ruby's CSV library will you give you back arrays if you open the file
with the CSV module.
I did notice that your file had this in it:
 "Subject ID:       1013938829432171e868c340.
Trial,stimulus,time,type,field1,field2,text_response,Abs. time of
response,,,,,

with the " not closing anywhere.  You might want to look at that, Excel
might be generating invalid CSV.  

Anyways, goodluck.
  .adam