Shell Programming and Scripting

 
limit.csv data
--------------
5600050 38Nhava
400077 27Bomay

 
rate.txt data
-------------
38NhaVA
27BomaY
27Bomay

 
for i in `cat limit.csv`
do
        b=`awk '{print $1}' $i`
        a=`awk '{print $2}' $i`
        grep -x "$a" rate.txt > /dev/null 2>&1
        if [ $? -eq 0 ]
        then
                rate=`grep -x "$a" rate.txt`
        else
                grep -i "$a" rate.txt > /dev/null 2>&1
                if [ $? -eq 0 ]
                then
                        rate=`grep -i "$a" rate.txt`
                        if [ `cat $rate | wc -l` > 1 ]
                        then
                                echo "There are duplicates for Rate Zone Codes $rate"
                                exit 1
                        fi
                fi
        fi
echo "$b,\"$rate\"" >> output.csv
done

 
 
awk: Cannot find or open file 5600050.
 The source line number is 1.
awk: Cannot find or open file 5600050.
 The source line number is 1.
cat: cannot open 38NhaVA
cat: cannot open 27BomaY
cat: cannot open 27Bomay

awk: Cannot find or open file 5600050.
 The source line number is 1.
cat: cannot open 38NhaVA

#!/bin/sh -xv

while read b a
do
...
done < limit.csv