Shell Programming and Scripting

awk 'NR==FNR{a[$1]=$2;next} ## NR>FNR means awk is reading through the "pattern" as input, also building an array a: a[$1]=$2. "next" means then start to read "report" 
{for(i=1;i<=NF;i++) if($i in a) print a[$i] FS $0}  ## if $i exsit in the array a, print a[$i](the value is from "pattern") and $0 
' pattern report

 awk code pattern report >tmp; cat tmp >report ;rm tmp

for i in `ls *.R`
do
cat sch.txt | while read LINE
do
CLT=`echo $LINE | cut -f1 -d "|"`
NAME=`echo $LINE | cut -f2 -d "|"`
NUM=`echo $LINE | cut -f3 -d "|"`
echo " $NAME $NUM$NAME "
comp_string=`grep "%s" $i| cut -d ":" -f2 | cut -d "|" -f1`
if [ $CLT = $comp_string ]
then
#NAME1=`grep $NAME $i` 
sed -i "/$NAME/s/.*/$NUM &/" $i
#cat $i | sed "s:$NAME:$NUM$NAME:g" > tmp_file.dat
#cat tmp_file.dat > $i
else
echo " Not Matching CLient Code"
fi
done
done