From: Salil Gaikwad <salil@...>
Date: 2009-03-03T00:46:31+09:00
Subject: how to read csv file which has :quote_char in data field

How to do this using fastercsv?

i want to read data from a csv file and save it into the database.
my file xyz.csv contains following line
,,,,"xyz",,,,
i want o/p of above row
as follows
nil,nil,nil,nil,"\"xyz\"", nil,nil,nil,nil

currently i get
nil,nil,nil,nil,"\"xyz\"",""

i am using following method to read the data
@parsed_file=FasterCSV.read("xyz.csv",  :col_sep =>",",
:quote_char=>',', :force_quotes => true)

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