Faster csv issue

Ruby
1

not sure why fastercsv cannot parse this. cannot find anything wrong
with my code either. why does it show invalid arguement. for eg

puts ie.text
“ClientAccountID”,“CurrencyPrimary”,“AssetClass”,“Symbol”,“OptionFutureCode”,“Quantity”,“MarkPrice”,“CostBasisPrice”

“6814789”,“USD”,“STK”,“CSUN”,"",“125”,“11.9800”,“12.1750”

“6814789”,“USD”,“STK”,“SIMO”,"",“150”,“20.0500”,“19.186667”
arr_of_arrs = FasterCSV.read(ie.text,{:col_sep => “,”,:headers=>true})
Invalid argument -
“ClientAccountID”,“CurrencyPrimary”,“AssetClass”,“Symbol”,“OptionFutureCode”,“Quantity”,“MarkPrice”,“CostBasisPrice”

“6814789”,“USD”,“STK”,“CSUN”,"",“125”,“11.9800”,“12.1750”

“6814789”,“USD”,“STK”,“SIMO”,"",“150”,“20.0500”,“19.186667”

2

On Jun 4, 2008, at 4:49 PM, Junkone wrote:

not sure why fastercsv cannot parse this. cannot find anything wrong
with my code either. why does it show invalid arguement.

I don’t see the "Invalid Argument error here, but you should be using
parse() instead of read(), if the content comes from a String:

#!/usr/bin/env ruby -wKU

require “rubygems”
require “faster_csv”

csv = <<END_CSV
"ClientAccountID
",“CurrencyPrimary
“,“AssetClass
“,“Symbol”,“OptionFutureCode”,“Quantity”,“MarkPrice”,“CostBasisPrice”
“6814789”,“USD”,“STK”,“CSUN”,””,“125”,“11.9800”,“12.1750”
“6814789”,“USD”,“STK”,“SIMO”,””,“150”,“20.0500”,“19.186667”
END_CSV

p FCSV.parse(csv, :col_sep => “,”, :headers => true)

END

Hope that helps.

James Edward G. II

3

On Jun 4, 6:06 pm, James G. [email protected] wrote:

require “rubygems”

p FCSV.parse(csv, :col_sep => “,”, :headers => true)

END

Hope that helps.

James Edward G. II

thanks james.