From: channa ly <chen.webdev@...>
Date: 2011-09-14T13:25:18+09:00
Subject: Re: csv file use excel to open and modify

I am using open office excel to open and modify the content of csv as 
well.

But i make sure that the csv separator is reversed. Because excel 
support more than one option of separator. Make sure that when you save 
your csv file the comma separator is still using.


I used to open my csv file with comma separated value. after modifying i 
save it without paying much attention on the open office instruction, 
then Open office modify my comma separator to semi-column separator then 
it make my ruby fail to read the csv content.


What i can say is: after saving the csv file, if somehow you can not 
read with your ruby program then u should take a took at the file with 
raw-text editor to double check is the comma separated is used.


let s me know if you get the idea.


thanks

-- 
Posted via http://www.ruby-forum.com/.