topic Re: Adding multiple lines up and getting a total in Operating System - HP-UX

Adding multiple lines up and getting a total

Warren griggs — Thu, 05 Jun 2003 12:02:13 GMT

Hi,

I have a file that looks like this...

45
34
23

What I need to do is add each line up to get a total.

ie for the example above ...

45+34+23 Total = 102

I think I need to use awk for this but cannot remember how.

Any help would be great.

Thanks,
Colin.

Re: Adding multiple lines up and getting a total

Geoff Wild — Thu, 05 Jun 2003 12:05:37 GMT

Try this:

awk 'BEGIN {total=0;} {total=total+$1;} END {print total,"\n";}'

Rgds...Geoff

Re: Adding multiple lines up and getting a total

Patrick Wallek — Thu, 05 Jun 2003 12:06:15 GMT

If the file just contains the single value you could do:

#!/usr/bin/sh

TOTAL=0
for i in $(cat file)
do
let TOTAL=$TOTAL+$i
done

echo "The total is $TOTAL"

Re: Adding multiple lines up and getting a total

Jarle Bjorgeengen — Thu, 05 Jun 2003 12:11:07 GMT

awk 'BEGIN {total=0} {total=total+$NF} END {print "Total is : " total} ' filename

Rgds Jarle

Re: Adding multiple lines up and getting a total

Robin Wakefield — Thu, 05 Jun 2003 12:14:43 GMT

...or...

perl -lne '{$t+=$_}END{print $t}' filename

rgds, Robin

Re: Adding multiple lines up and getting a total

Jean-Louis Phelix — Thu, 05 Jun 2003 12:51:11 GMT

Perhaps you will like this one ...

echo $(($(cat file | tr '\012' '+')0))

Regards.

Re: Adding multiple lines up and getting a total

Chris Vail — Thu, 05 Jun 2003 17:51:48 GMT

In Unix, there's always several different ways to do any one thing. You've already got some good ones, here's another:
#!/bin/ksh
for AMOUNT in `cat $FILE`
do
(( TOTAL = "$TOTAL" + "$AMOUNT" ))
done
echo $TOTAL

Chris

Re: Adding multiple lines up and getting a total

John Meissner — Thu, 05 Jun 2003 18:22:10 GMT

or yet another way....

number=$(cat file)
e=0
for i in $number
do
((e=e+$i))
done
echo $e

now if you have multiple columns in your file you can just change the value to $number to assign the field you wish to add up.

i.e.
number=$(cat file | awk '{print $2}')

and the 2nd field would be added