S
Salil Gaikwad
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
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