Shell Programming and Scripting

Good point! UUoC I believe
Well spotted!

hello, I got stuck again,
how to make this table convert horizontally :

userA var1 1000
userA var1 1200
userA var2 2000
userA var2 1000
userB var2 3000
userB var3 4000
userB var3 2000
userB var4 5000
userC var1 6000

become like this table :
userA 2200 3000 0 0
userB 0 3000 6000 5000
userC 6000 0 0 0

with this format :
user (sum col3 where col2=var1 && col1=user) (sum col3 where col2=var2 && col1=user) (sum col3 where col2=var3 && col1=user) (sum col3 where col2=var4 && col1=user)

very very thanks again for your helps.....


regards,

please correct my script with more efficient sript :

Code:

awk '
NR==FNR{user[$1]=$1;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"]
}
' file file

thank you...