not sure what is wrong here.

J

Junkone

i am not sure what is wrong here
tablearr is of type FASTERCSV::TABLE
eachrow is of type FASTERCSV::ROW
as per the fastercsv doc, the table.values_at returns a array.
the array has method .include?<searchcriteria>

def checkduplicates(eachrow,tablearr,indx,criteria)
eachrow.each{|name,valu|
rowdata=tablearr.values_at(indx+criteria)
if(rowdata.include?valu)<<<<<<<<<<<<< ERROR HERE.
puts "match"
end

}

c:/ruby/lib/ruby/gems/1.8/gems/fastercsv-1.2.0/lib/faster_csv.rb:
345:in `==': undefined method `row' for "03":String (NoMethodError)
from scan.rb:7:in `include?'
 
J

James Edward Gray II

i am not sure what is wrong here
tablearr is of type FASTERCSV::TABLE
eachrow is of type FASTERCSV::ROW
as per the fastercsv doc, the table.values_at returns a array.
the array has method .include?<searchcriteria>

def checkduplicates(eachrow,tablearr,indx,criteria)
eachrow.each{|name,valu|
rowdata=tablearr.values_at(indx+criteria)
if(rowdata.include?valu)<<<<<<<<<<<<< ERROR HERE.
puts "match"
end

}

c:/ruby/lib/ruby/gems/1.8/gems/fastercsv-1.2.0/lib/faster_csv.rb:
345:in `==': undefined method `row' for "03":String (NoMethodError)
from scan.rb:7:in `include?'

I'm happy to help debug this, but it would be much easier if I had
some code I could run. Could you try reducing the error to a simple
little script, using included dummy data, that shows the problem?
When I see that, I'm sure I can provide some suggestions.

James Edward Gray II
 
J

Junkone

I'm happy to help debug this, but it would be much easier if I had
some code I could run. Could you try reducing the error to a simple
little script, using included dummy data, that shows the problem?
When I see that, I'm sure I can provide some suggestions.

James Edward Gray II- Hide quoted text -

- Show quoted text -

Hello
Thanks for your response. attaching the script and data


data
No,S/W,Day,Month,Year,N1,N2,N3,N4,N5,N6,Bn,Sum
1,Sat,12 ,June,1982,03,11,12,14,41,43,13,124
2,Sat,19 ,June,1982,08,33,36,37,39,41,09,194
3,Sat,26 ,June,1982,06,01,23,24,27,39,34,120
4,Sat,03 ,July,1982,03,09,10,13,20,43,34,98
5,Sat,10 ,July,1982,05,14,21,31,34,47,45,152
6,Sat,17 ,July,1982,08,20,21,25,31,41,33,146
7,Sat,24 ,July,1982,18,25,28,33,36,42,07,182


script
require "faster_csv"
SEARCH_CRITERIA=1

def checkduplicates(eachrow,tablearr,indx,criteria)
eachrow.each{|name,valu|
rowdata=tablearr.values_at(indx+criteria)
if(rowdata.include?valu)
puts "match"
end

}


end


tablearr = FasterCSV.read("c:\\ruby\\testing\\data.txt",
{:headers=>true,:skip_blanks=>true})
tablearr.by_col!()

tablearr.delete("No")
tablearr.delete("S/W")
tablearr.delete("Day")
tablearr.delete("Month")
tablearr.delete("Year")
#puts tablearr
tablearr.by_row!()
tablearr.each_with_index{|eachrow,indx|
checkduplicates(eachrow,tablearr,indx,SEARCH_CRITERIA)

# puts indx
}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,007
Latest member
obedient dusk

Latest Threads

Top