Shell Programming and Scripting

Item     Amount      Item Name     Price
11        1              X                  $1.00
12        1              Y                  $1.00
15        1              W                 $1.00
12        1              Y                  $1.00
13        1              Z                  $1.00
12        1              Y                  $1.00
12        1              Y                  $1.00

Item     Category
11        Cat
12        Dog
13        Fish
14        Bird
15        Pig

Item     Amount      Item Name     Price    Category
11        1              X                  $1.00    Cat
12        1              Y                  $1.00    Dog
15        1              W                 $1.00    Pig
12        1              Y                  $1.00    Dog
13        1              Z                  $1.00    Fish
12        1              Y                  $1.00    Dog
12        1              Y                  $1.00    Dog

script.sh
#!/bin/bash
fname=$1
head -n 2000 $fname | awk -F t '{print $30, $32, $33, $33 - 0.40 ,$28}' > "cache.txt"
while read itemNo Category
do
     sed  -i s/"$itemNo"/"$Category"/g cache.txt > cache.txt
done < "key.txt"

awk 'NR==FNR{a[$1]=$2;next} a[$1]{print $0,a[$1]}' ConversionTable TransactionLog