adding numbers in a file 3

[chanman525]

Hey all. I've got a file that looks like the following:

81011, prt8, 0
81006, prt8, 28085
81009, prt8, 925
81011, prt8, 0
81006, prt8, 28085
81009, prt8, 925

All I want to do is add the numbers in the third column. Right now I've got...

cat test | read a1 a2 a3
sum $a3

but it's just saying that 0 cannot be found. Am I going about this the right way?

Thanks for any help you can give.

 

[khalidaaa]

I know that can be done easily by awk!

I will test it and come back to you

Regards,
Khalid

 

[sbrews]

not awk (my awk-fu is weak), but a ksh solution:

total=0
while read -r a1 a2 a3
do
read a1 a2 a3
(( total=total+$a3 ))
done < numbers.txt
echo "total = $total"

 

[khalidaaa]

That's how i did it

cnt=0
for i in `awk '{print $3}' readnums`
do
((cnt=cnt + i))
done
echo $cnt

I know its not the perfect way of using awk any way

But it works

Regards,
Khalid

 

[sbrews]

Eeek. Just looked over my solution - The read after the "do" statement - it doesnt belong, remove it.

 

[chanman525]

I didn't think so, but I don't question you AIX guru's.

Thanks for the help from both of you. Not sure which one I'll go with, but they both work great.

Thanks again guys.

 

[p5wizard]

awk '{sum+=$3} END{print sum}' /path/to/file


HTH,

p5wizard

 

[sbrews]

p5wizards' awk-fu is not weak.

 

[p5wizard]

This is just plain stuff. Y'all should check out some of the code examples the real gurus over at the AWK forum forum271 dish out...

p5

 

[khalidaaa]

Oh yeah that's what i was trying to do

Thanks p5wizard

Regards,
Khalid

 

[dsn1]

awk '/.*/ {
total_count=total_count+$3
}
\END {
print total_count
}' /filename

should do the trick

Dave

 

[dsn1]

oops... missed a tidier awk solution a cpl of posts earlier

 

[mrn]

And heres a nice little tutorial to expand your knowledge.

http://robert.wsi.edu.pl/awk/tutorial_7a.html

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."