UNIX for Dummies Questions & Answers

Hello everyone!!

I have to write a script in unix that reads a file which is in the format:
1%blabla%30
2%blabla2%50
1%blabla3%40
2%blabla4%10

and produce the total quantities of 1 and 2: "1 = 70 2 = 60"

I am taught basic unix commands, so I must keep it simple, how can i do this using loops? (I am not supposed to use functions)

I suppose that I should extract the 1st and 2nd column from the file, but after that I don't know what to do!!

Any help would be appreciated!!!! Thank youuuuuuuu!

Can you show what you tried?

somebody will come and question you because it seems like a homework qns, but nevertheless,

Code:

awk 'BEGIN{FS="%"} { arr[$1]+=$3} END{ for(i in arr) print i " " arr[i]}' "file"

Although this sounds like a homework question here is one answer. I am sure you will get more compact answers from those more accustom to AWK.

create enttab to contain

1%blabla%30
2%blabla2%50
1%blabla3%40
2%blabla4%10


for name in `cat enttab`
do
echo $name
frst=`echo $name | cut -f 1 -d %`
scnd=`echo $name | cut -f 3 -d %`
echo $frst $scnd
done

The only thing I can do is cut -f 1,3 -d '%' {filename}
I am a bit lost after that & I am certainly not bored to solve it, I just don't know how to do it!!

I am not familiar to awk anyway!! Thanks a lot but I know how to extract the columns. I don't know how to sum the contents of the thrird one!

Ofcourse it is a homework!!!!
Is that so bad to ask for directions? I don't want you to solve the exercise!
I just want you to tell my how to add the numbers of the third column


Thank you in advance!