UNIX for Dummies Questions & Answers

$ ./process_it.sh 
T       1       2       3       JOHN    1000
T       4       5       6       TOM     2000
T       3       7       9       MIKE    6000
$ cat ./process_it.sh 
#!/bin/bash

FILE1=file1
FILE2=file2

# All FS are a literal tab - use \t if your awk supports it
while read LINE; do
   ID=$( echo "${LINE}" | awk 'BEGIN {FS="      "} {printf("%s\t%s\t%s\n",$2,$3,$4)}' )
   MATCH=$( egrep "^${ID}" ${FILE2} )
   if [ "${MATCH}" != "" ]; then
      PART1=$( echo "${LINE}" | awk 'BEGIN {FS="        "} {print $1}' )
      PART2=$( echo "${LINE}" | awk 'BEGIN {FS="        "} {print $NF}' )
      printf "${PART1}\t${MATCH}\t${PART2}\n"
   fi
done < ${FILE1}

exit 0

awk 'FNR==NR{arr[$2" "$3" "$4]=$0;next}
{
        s=$1" "$2" "$3
        if(s in arr){
                print arr[s],$NF
        }
}
' "file" "file1"

 ./testnew.sh
T 1 2 3 1000 JOHN
T 4 5 6 2000 TOM
T 3 7 9 6000 MIKE