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@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@Heiko.Edu
>
>
> 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...@Heiko.Edu"
> 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@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
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"
>On 2007-12-05, Heiko@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
> On Wed, 5 Dec 2007 13:56:17 -0500, "Chris F.A. Johnson"
>
> >On 2007-12-05, He...@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"
>
>>On 2007-12-05, Heiko@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
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@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@gmail.com wrote:
> On Dec 5, 8:43 am, "He...@Heiko.Edu"
>> 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 @ hp : com
Heiko@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 @ hp : com
On 06 Dec 2007 07:19:30 GMT, Stephane Chazelas
>On Wed, 5 Dec 2007 13:56:17 -0500, Chris F.A. Johnson wrote:
>> On 2007-12-05, Heiko@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