Search Results

Wow! Thanks. This looks so simple compared to a while in a while. I'll give it a try and see. You rock!

So no one knows how to do this without a while of 20K records (fileB) with another 200K records (fileA)? Would be even better if someone knows how to just work with fileA and for each record in fileA...

I have two files:

fileA
a,b,c,10,apple
a,b,c,20,orange
a,b,c,10,grape
d,e,f,5,pear
d,e,f,100,pear
x,y,z,15,lemon
x,y,z,20,apple
x,y,z,30,grape

fileB
a,b,c,20
d,e,f,100
x,y,z,30

If...