[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

faster csv issue

Junkone

6/4/2008 9:45:00 PM

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 Answers

James Gray

6/4/2008 10:07:00 PM

0

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 Gray II

Junkone

6/5/2008 5:26:00 PM

0

On Jun 4, 6:06 pm, James Gray <ja...@grayproductions.net> wrote:
> 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 Gray II

thanks james.