Math Adding

[jestrada101]

How can I add data?

---data----
TEAMA 100
TEAMB 200
TEAMC 300
-----------

how can I read this data in and add to get a total of 600?

Thanks
JE

 

[Salem]

Awk can do tbis quite easily

awk '{ sum += $2 }
END { print sum }' data

data being the name of your data file with numbers in field 2

--

 

[jestrada101]

Thanks...
if one has a variable with data stored in it.. how can one read it in to add...

for example..
we have teh file data again...

RESULTS=`cat data`

then there is column 2 in data that I need to add... is this possible?

 

[Salem]

RESULTS=`cat data`
But this removes all the newlines from the file and leaves you with a single line containing

TEAMA 100 TEAMB 200 TEAMC 300

Sure you could do something, but it seems to be adding a layer of difficulty over my first answer.

--

 

[PHV]

In ksh, provided your data file have less than 512 lines, you can try something like this:

set -A arr $RESULTS
typeset -i i=0 tot=0
while [ $i -lt ${#arr[*]} ]; do
  tot=$((tot+${arr[$((i+1))]}))
  i=$((i+2))
done
echo $tot

Hope This Help
PH.

 

[marsd]

Use salems instructions but encapsulate and print
the command to store the value in a shell variable.

sum=`awk '{sum += $2 } END {print sum}'`
echo $sum