Shell Programming and Scripting

#!/bin/sh
cat file1 | while read line
do
  username=`echo $line | awk '{ print $1 }'`
  params=`echo $line | awk '{ print $2,$3 }'`
  for file in file2 file3
  do
    egrep "$username " $file | while read line
    do
      echo "0" > var1.$$
      echo "0" > var2.$$
      echo "0" > var3.$$
      echo "0" > var4.$$
      varval=`echo $line | awk '{ print $3 }'`
      case `echo $line | awk '{ print $2 }'` in
      var1) echo $varval > var1.$$
        ;;
      var2) echo $varval > var2.$$
        ;;
      var3) echo $varval > var3.$$
        ;;
      var4) echo $varval > var4.$$
        ;;
      esac
    done
    params="$params `cat var1.$$` `cat var2.$$` `cat var3.$$` `cat var4.$$`"
  done
  echo "$username $params"
done
rm -f var1.$$ var2.$$ var3.$$ var4.$$

nawk '
NR==FNR{user[$1]=$0;userv[$1"1"]=0;userv[$1"2"]=0;userv[$1"3"]=0;userv[$1"4"]=0}
NR!=FNR{
if($2=="var1")
	userv[$1"1"]=$3
else if($2=="var2")
	userv[$1"2"]=$3
else if($2=="var3")
	userv[$1"3"]=$3
else if($2=="var4")
	userv[$1"4"]=$3
}
END{
for(i in user)	
	print user[i]" "userv[i"1"]" "userv[i"2"]" "userv[i"3"]" "userv[i"4"]
}
'  file1 file2 > temp

nawk '
NR==FNR{user[$1]=$0;userv[$1"1"]=0;userv[$1"2"]=0;userv[$1"3"]=0;userv[$1"4"]=0}
NR!=FNR{
if($2=="var1")
	userv[$1"1"]=$3
else if($2=="var2")
	userv[$1"2"]=$3
else if($2=="var3")
	userv[$1"3"]=$3
else if($2=="var4")
	userv[$1"4"]=$3
}
END{
for(i in user)	
	print user[i]" "userv[i"1"]" "userv[i"2"]" "userv[i"3"]" "userv[i"4"]
}
'  temp file3
rm temp