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
}
···
On Jun 6, 9:50 am, James Edward Gray II <j...@grayproductions.net> wrote:
On Jun 6, 2007, at 8:30 AM, Junkone wrote:
> 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- Hide quoted text -
- Show quoted text -