Adding up numbers in a file

[Ferdie Castro]

Hi just wanna ask how to develop a script. I have a file abc -- each lines contain numbers some decimals. I was having problem in adding up all the numbers because of this decimal thing. thanks

[Michael Steele_2]

Regarding "...this decimal thing..."

Why don't you use the programming languague that Unix was written in? 'C'?

Here's someones C program:

http://forums1.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0xa16a46ff9277d511abcd0090277a778c%2C00.html&admit=716493758+1066359015637+28353475


Integer addition :

x=$(($x+1))

[curt larson_1 · Accepted solution]

use a shell that supports decimal numbers
#!/usr/dt/bin/dtksh
typeset -F total=0

cat yourfile |
while read number
total=$(( $total + $number ))
done
print $total

use a program that supports decimal numbers
#!/usr/bin/ksh

cat yourfile |
awk '{
total += $1;
} END {printf("%f\n",total)}'

or bc, perl, write your own

[Mark Grant]

Or use bc

#/usr/bin/sh

bc |&
TOTAL=0
while read num
do
print -p "$TOTAL + $num"
read -p TOTAL
done < myfile

echo $TOTAL

[Graham Cameron_1]

Or use awk.
Don't know how many cols your input file has, but assuming each line has 3 cols, each line of which you want totalling, then use:
--
cat yourfile|awk '
{tot1+=$1;tot2+=$2;tot3+=$3}
END {printf "Totals: %f, %f, %f\n", tot1, tot2, tot3}
'
--
This can be extended to the general case.
-- Graham

[Martha Mueller]

I think Mark needs to add:

print -p scale = 2

to get 2 places to the right of the decimal point.