topic Re: Awk sum script in Operating System - HP-UX

Awk sum script

Eugene Matusovsky — Fri, 08 Jan 2010 00:55:45 GMT

I have text file

1
2
3

I would like to use awk to sum up the total of these numbers and output the number 6.

Is this possible in awk?

Re: Awk sum script

R.K. # — Fri, 08 Jan 2010 01:08:20 GMT

Hi Eugene,

# cat a1
1
2
3

# awk 'BEGIN {sum=0}{sum+=$1} END {print sum}' < a1
6

Hope this helps..!

Re: Awk sum script

Kapil Jha — Fri, 08 Jan 2010 03:07:02 GMT

awk '{ s += $1 } END { print "sum: ", s }' abc

abc is file name.

BR,
Kapil+

Re: Awk sum script

Dennis Handly — Fri, 08 Jan 2010 09:10:59 GMT

>I would like to use awk to sum

awk(1) has an example that does that.

Re: Awk sum script

Eugene Matusovsky — Fri, 08 Jan 2010 15:54:03 GMT

This all great! Thanks so much for everyone's help. I'm also considering doing the sum in ksh/bash only...Is this possible?

Thank You

Re: Awk sum script

OldSchool — Fri, 08 Jan 2010 16:14:19 GMT

sure...for integer math

typeset i sum
typeset i incr

sum=0
echo $sum

while read incr;
do

let sum=$sum+$incr
echo $sum
done < yourfile

there are also methods involving bc that will do reals/floats

Re: Awk sum script

Dennis Handly — Fri, 08 Jan 2010 16:54:34 GMT

>OldSchool: let sum=$sum+$incr

You may want to just use:
(( sum += incr ))

Re: Awk sum script

James R. Ferguson — Fri, 08 Jan 2010 17:16:51 GMT

Hi:

> Thanks so much for everyone's help. I'm also considering doing the sum in ksh/bash only...Is this possible?

Yes, as OldSchool showed you, the shell can do this. Beware that in HP-UX, the Posix ('/usr/bin/sh') shell limits you to 32-bit arithmetic. If you are running 11.23 or later, the Korn shell ('/usr/bin/ksh') will support 64-bit arithmetic.

Running OldSchool's code and adding the numbers found in an input file:

1
2147483648
2
3

...yields:

-2147483642

Changing to a Korn shell yields the correct value:

2147483654

Also:

typeset i sum

...should be:

typeset -i sum

Regards!

...JRF...