Joining two files

[baccala]

Hi! I relatively new to using linux. I have 2 files I need to join the FILE1 to FILE2 based on the first field(ie abc...) , if there is a match on FILE2 then if see if FILE1 field2 is between the range in FILE2? If its between range then continue if its outside of range then fail script
Please help! Thanks! See file example below


FILE1
abc 33
def 22
xyz 15

FILE2
abc 25 70
ddw 12 55
def 20 30
qwe 33 77
xyz 20 55

[oz]

Welcome to the forums!

Is this a homework question?

[baccala]

Its actually some monitoring I'm trying to put in our system. I just mocked up the data instead of using our actual data. I wrote a sqlplus that creates the FILE1 and need to compare it FILE2 and if there is a match(on the key) then check to see if its within the allowable range. If yes move on to the next value to check, if not then fail the script. In which I'll add in my logic to page me.

Thanks!

[Franklin52]

Try this:

awk 'FNR == NR {key[$1]=$1;num[$1]=$2;next;}
{
  for ( i in key ) {
    if ($1 == i && ( num[i] < $2 || num[i] > $3 )) {
      print "This line is out of range: "$0
    }
  }
}' "FILE1" "FILE2"

Regards

[drl]

Hi.

I like Franklin52's solution because it is all in one piece. Here's a similar solution, but using a Linux utility:

#!/usr/bin/env sh#!/usr/bin/env sh

# @(#) s1       Demonstrate join.

set -o nounset
echo

debug=":"
debug="echo"

## Use local command version for the commands in this demonstration.

echo "(Versions of codes used in this script with local utility \"version\")"
version bash join awk

echo

join FILE1 FILE2 |
awk '
$2 < $3 || $2 > $4      { print "Out of bounds: " $0 }
'

exit 0

Producing:

% ./s1

(Versions of codes used in this script with local utility "version")
GNU bash, version 2.05b.0(1)-release (i386-pc-linux-gnu)
join (coreutils) 5.2.1
GNU Awk 3.1.4

Out of bounds: xyz 15 20 55

cheers, drl

[baccala]

Thanks you both for your suggestions, I used Franklin52's solution. Now I will work on incorporating this into the rest of my processing.

Thanks again. My first experience in a forum has been most helpful.