Hello all,

I have a file in the format like this:

2
85
982
1067
13924
25892

I would like to be able to sum these.

I have read the man pages, google groups, O'Reilly texts, etc, and
have come up empty.

Any help is much appreciated... and no, this is not a homework
assignment - this is a project for my job.

Regards,

Heiko

On 12/5/2007 8:43 AM, Heiko [at] Heiko.Edu wrote:
> Hello all,
>
> I have a file in the format like this:
>
> 2
> 85
> 982
> 1067
> 13924
> 25892
>
> I would like to be able to sum these.
>
> I have read the man pages, google groups, O'Reilly texts, etc, and
> have come up empty.
>
> Any help is much appreciated... and no, this is not a homework
> assignment - this is a project for my job.
>
> Regards,
>
> Heiko

awk '{s+=$0}END{print s}' file

Ed.

On 2007-12-05, Heiko [at] Heiko.Edu <Heiko [at] Heiko.Edu> wrote:
>
>
> Hello all,
>
> I have a file in the format like this:
>
> 2
> 85
> 982
> 1067
> 13924
> 25892
>
> I would like to be able to sum these.
>
> I have read the man pages, google groups, O'Reilly texts, etc, and
> have come up empty.
>
awk '{sum += $1} END{print sum}'

On Dec 5, 8:43 am, "He... [at] Heiko.Edu" <He... [at] Heiko.Edu> wrote:
> Hello all,
>
> I have a file in the format like this:
>
> 2
> 85
> 982
> 1067
> 13924
> 25892
>
> I would like to be able to sum these.
>
> I have read the man pages, google groups, O'Reilly texts, etc, and
> have come up empty.
>
> Any help is much appreciated... and no, this is not a homework
> assignment - this is a project for my job.
>
> Regards,
>
> Heiko

you can either do it with 'bc' or you may need to write a script like
so

------------------------------------------------------------ ------------------
#!/bin/ksh

INPUT_FILE=$1
set -A SUM `cat $INPUT_FILE`
index=1
elements=`wc -l $INPUT_FILE|awk '{print $1}'`

NEW_SUM=${SUM[0]}
while [[ $index -lt $elements ]]; do
NEW_SUM=`expr $NEW_SUM + ${SUM[$index]}`
index=`expr $index + 1`
done

echo $NEW_SUM
------------------------------------------------------------ ------------------

where INPUT_FILE is the elements you want to sum. However this will
only work for 1023 elements.

HTH

On 2007-12-05, Heiko [at] Heiko.Edu wrote:
>
> I have a file in the format like this:
>
> 2
> 85
> 982
> 1067
> 13924
> 25892
>
> I would like to be able to sum these.

echo $(( $( tr '\012' '+' < FILE ) 0 ))

--
Chris F.A. Johnson, author <http://cfaj.freeshell.org/shell/>
Shell Scripting Recipes: A Problem-Solution Approach (2005, Apress)
===== My code in this post, if any, assumes the POSIX locale
===== and is released under the GNU General Public Licence

On Wed, 5 Dec 2007 13:56:17 -0500, "Chris F.A. Johnson" <cfajohnson [at] gmail.com> wrote:

>On 2007-12-05, Heiko [at] Heiko.Edu wrote:
>>
>> I have a file in the format like this:
>>
>> 2
>> 85
>> 982
>> 1067
>> 13924
>> 25892
>>
>> I would like to be able to sum these.
>
>echo $(( $( tr '\012' '+' < FILE ) 0 ))
^--> What is this zero doing please?

Grant.

On Dec 5, 1:06 pm, Grant <g_r_a_n... [at] dodo.com.au> wrote:
> On Wed, 5 Dec 2007 13:56:17 -0500, "Chris F.A. Johnson" <cfajohn... [at] gmail.com> wrote:
>
> >On 2007-12-05, He... [at] Heiko.Edu wrote:
>
> >> I have a file in the format like this:
>
> >> 2
> >> 85
> >> 982
> >> 1067
> >> 13924
> >> 25892
>
> >> I would like to be able to sum these.
>
> >echo $(( $( tr '\012' '+' < FILE ) 0 ))
>
> ^--> What is this zero doing please?
For the last line, I guess.

On 2007-12-05, Grant wrote:
>
>
> On Wed, 5 Dec 2007 13:56:17 -0500, "Chris F.A. Johnson" <cfajohnson [at] gmail.com> wrote:
>
>>On 2007-12-05, Heiko [at] Heiko.Edu wrote:
>>>
>>> I have a file in the format like this:
>>>
>>> 2
>>> 85
>>> 982
>>> 1067
>>> 13924
>>> 25892
>>>
>>> I would like to be able to sum these.
>>
>>echo $(( $( tr '\012' '+' < FILE ) 0 ))
> ^--> What is this zero doing please?

Making it a valid expression. Look at the output of tr.

--
Chris F.A. Johnson, author <http://cfaj.freeshell.org/shell/>
Shell Scripting Recipes: A Problem-Solution Approach (2005, Apress)
===== My code in this post, if any, assumes the POSIX locale
===== and is released under the GNU General Public Licence

On Wed, 5 Dec 2007 13:56:17 -0500, Chris F.A. Johnson wrote:
> On 2007-12-05, Heiko [at] Heiko.Edu wrote:
>>
>> I have a file in the format like this:
>>
>> 2
>> 85
>> 982
>> 1067
>> 13924
>> 25892
>>
>> I would like to be able to sum these.
>
> echo $(( $( tr '\012' '+' < FILE ) 0 ))

It should ne noted, that contrary to the awk solution, that one
doesn't scale very well as it stores the whole addition
expression in memory before computing it. While the awk one does
the addition while reading the file. So for big files, it will
waste a lot of memory. The awk solution will also behave better
if there are lines that don't look like numbers.

In case files may be empty, one may prefer:

awk '
{sum += $0}
END {print sum + 0}' < FILE

To be sure "0" is output in that case.

--
Stephane

chris.l.bryant [at] gmail.com wrote:
> On Dec 5, 8:43 am, "He... [at] Heiko.Edu" <He... [at] Heiko.Edu> wrote:
>> Hello all,
>>
>> I have a file in the format like this:
>>
>> 2
>> 85
>> 982
>> 1067
>> 13924
>> 25892
>>
>> I would like to be able to sum these.
>>
>> I have read the man pages, google groups, O'Reilly texts, etc, and
>> have come up empty.
>>
>> Any help is much appreciated... and no, this is not a homework
>> assignment - this is a project for my job.
>>
>> Regards,
>>
>> Heiko
>
> you can either do it with 'bc' or you may need to write a script like
> so
>
> ------------------------------------------------------------ ------------------
> #!/bin/ksh
>
> INPUT_FILE=$1
> set -A SUM `cat $INPUT_FILE`
> index=1
> elements=`wc -l $INPUT_FILE|awk '{print $1}'`
>
> NEW_SUM=${SUM[0]}
> while [[ $index -lt $elements ]]; do
> NEW_SUM=`expr $NEW_SUM + ${SUM[$index]}`
> index=`expr $index + 1`
> done
>

Too complicated!

#!/bin/ksh
sum=0
while read element
do
sum=$((sum+$element))
done < file
echo $sum

--
Michael Tosch [at] hp : com

Heiko [at] Heiko.Edu wrote:
> Hello all,
>
> I have a file in the format like this:
>
> 2
> 85
> 982
> 1067
> 13924
> 25892
>
> I would like to be able to sum these.
>
> I have read the man pages, google groups, O'Reilly texts, etc, and
> have come up empty.
>
> Any help is much appreciated... and no, this is not a homework
> assignment - this is a project for my job.
>
> Regards,
>
> Heiko
>
>

For very big numbers use this:

awk '{print "x+=" $1+0} END {print "x"}' file | bc


--
Michael Tosch [at] hp : com

On 06 Dec 2007 07:19:30 GMT, Stephane Chazelas
<stephane_chazelas [at] yahoo.fr> wrote:

>On Wed, 5 Dec 2007 13:56:17 -0500, Chris F.A. Johnson wrote:
>> On 2007-12-05, Heiko [at] Heiko.Edu wrote:
>>>
>>> I have a file in the format like this:
>>>
>>> 2
>>> 85
>>> 982
>>> 1067
>>> 13924
>>> 25892
>>>
>>> I would like to be able to sum these.
>>
>> echo $(( $( tr '\012' '+' < FILE ) 0 ))
>
>It should ne noted, that contrary to the awk solution, that one
>doesn't scale very well as it stores the whole addition
>expression in memory before computing it. While the awk one does
>the addition while reading the file. So for big files, it will
>waste a lot of memory. The awk solution will also behave better
>if there are lines that don't look like numbers.
>
>In case files may be empty, one may prefer:
>
>awk '
> {sum += $0}
> END {print sum + 0}' < FILE
>
>To be sure "0" is output in that case.

Thanks to all for their suggestions - works great.

-Heiko