Shell Programming and Scripting

Hey,

I have 2 files that have a name and then a number:

File 1:

dog 21
dog 24
cat 33
cat 27
dog 76
cat 65

File 2:

dog 109
dog 248
cat 323
cat 207
cat 66
cat 265

I'd like to query column 1 in file 1 and file 2 for identity and then do a math operation. on column 2 from file 1 and file 2.

e.g. if the string in column 1 from file 1 == the string in column 1 from file 2 and if the value of the number in column 2 - the number in file 2 column 2 is > 100 && < 200 print a line with that row with the string, the two numbers and the value of the difference.

Basically and all by all lookup.

dog 21 (from file 1) would be compared to everything in file 2

dog 109
dog 248
cat 323
cat 207
cat 66
cat 265

then

dog 24 would be compared to everything and so on.

I'm a newbie and don't know how to send 2 columns from 2 files through a lookup array.

Any help would be great. - I'll add that these files are large so an ideal solution would be efficient.

Thanks so much (thanks for the edit)

Ughm, You mean >100 AND <200 right? >100 OR <200 will pretty much return everything!

Try this...

#!/bin/bash

cat file1 | while read key value
do
cat file2 | while read keyA valueA
do
[[ "$key" == "$keyA" ]] && {
((diff=$valueA-$value))
[[ $diff -gt 100 && $diff -lt 200 ]] && echo "$key $value $valueA $diff"
}
done
done

Yeah AND && sorry. I'm really new.