topic Re: Adding a column of numbers in a file in Operating System - HP-UX

Adding a column of numbers in a file

Paddy O'Connell — Mon, 26 Mar 2007 05:57:14 GMT

Hi,

I'm looking to total up all the numbers in a file as part of a shell script.

sample file is like below, now i'll have hundreds of numbers

68
8
2
2

Thanks
Paddy

Re: Adding a column of numbers in a file

Peter Godron — Mon, 26 Mar 2007 06:01:07 GMT

Paddy,
you don't mention a preference for solution, so here is one in awk:
awk 'BEGIN {total=0;} {total=total+$1;} END {print total,"\n";}' data.lis

Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

Re: Adding a column of numbers in a file

Paddy O'Connell — Mon, 26 Mar 2007 06:08:52 GMT

Thanks Peter for quick response i'll try it.

As part of the same script all these numbers are generated into a file. I want to total the number in them and if it's above a certain treshold it will mail me.

So will i cat the file with all numbers in it and pipe it to your awk command you supplied?

Paddy

Re: Adding a column of numbers in a file

Paddy O'Connell — Mon, 26 Mar 2007 06:13:02 GMT

It's ok Peter, i removed the data.lis you put at the end and it's set to cat the file and pipe to awk.
Thanks for that

Paddy

Re: Adding a column of numbers in a file

Peter Godron — Mon, 26 Mar 2007 06:15:24 GMT

Paddy,
my test was:
$ cat a.lis
1.1
2.5
3
4
$ level=`awk 'BEGIN {total=0;} {total=total+$1;} END {print total,"\n";}' a.lis`
$ echo $level
10.6
$
Just to check that it worked with float as well.

In your case you can use the $level bit to then decide whether to mail. Something like:

level=`awk ....
if [ $level -gt 75 ]
then
echo "Level is $level" | mailx -s "level reached" usr@aol.com
fi