addition of both positive and negative numbers


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting addition of both positive and negative numbers
# 8  
Old 11-10-2010
Most likely all other operations could be made easier with awk as well, but if you insist....
Code:
#!/bin/ksh
#set -x

sum=0
while read num
do
  num=$(echo $num|sed 's/+//g')
  sum=$(echo "$sum + $num" |bc)
done < myFile
echo $sum

# 9  
Old 11-10-2010
In ksh93 it is easy without external programs:
Code:
sum=0
while read val
do
  (( sum+=val ))
done < infile
echo $sum

Or in any Posix compliant shell:
Code:
str=0
while read val
do
  str="$str $val"
done < infile
echo $str | bc

It can also be done like this, without a loop:
Code:
v=$(cat infile); echo ${v#?} | bc


Last edited by Scrutinizer; 11-10-2010 at 11:06 AM.. Reason: Should be ksh93, and posix compliant shell
# 10  
Old 11-10-2010
Quote:
Originally Posted by Scrutinizer
In ksh it is easy without external programs:
not all ksh-s provide floating point arithmetics
Quote:
Originally Posted by Scrutinizer
Code:
sum=0
while read val
do
  (( sum+=val ))
done < infile
echo $sum

Or in any shell:
This doesn't work with Solaris' Bourne shell (/bin/sh)
Quote:
Originally Posted by Scrutinizer
Code:
str=0
while read val
do
  str="$str $val"
done < infile
echo $str | bc

It can also be done like this, without a loop:
Code:
v=$(cat infile); echo ${v#?} | bc

# 11  
Old 11-10-2010
Quote:
Originally Posted by vgersh99
not all ksh-s provide floating point arithmetics
Correct, that should be ksh93.
Quote:
This doesn't work with Solaris' Bourne shell (/bin/sh)
It works with any Posix shell (so /usr/xpg4/bin/sh on Solaris).
But this should just work in Bourne shell as well, shouldn't it? Did you try?
-----
edit: Ah, I see you did not mean the loop but the second part: because of the $() .
Then you can use:
Code:
v=`cat infile`; echo ${v#?} | bc


Last edited by Scrutinizer; 11-10-2010 at 11:02 AM..
# 12  
Old 11-10-2010
Code:
paste -sd+ myFile | sed 's/+\([+-]\)/\1/g;s/^+//'|bc

---------- Post updated at 10:01 AM ---------- Previous update was at 10:00 AM ----------

Quote:
Originally Posted by Scrutinizer
Correct, that should be ksh93.

It works with any Posix shell (so /usr/xpg4/bin/sh on Solaris).
But this should just work in Bourne shell as well, shouldn't it? Did you try?
I did try it with Solaris' Bourne (/bin/sh) - 'str' doesn't hold the value outside the loop.
# 13  
Old 11-10-2010
Quote:
Originally Posted by vgersh99
This doesn't work with Solaris' Bourne shell (/bin/sh)
So what? That's an ancient, dessicated stub.
# 14  
Old 11-10-2010
Quote:
Originally Posted by Corona688
So what? That's an ancient, dessicated stub.
Just sayin'....
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Splitting a file based on negative and positive numbers

I have a file that is pipe delimited and in Column F they have number values, both positive and negative. I need to take the one file I am starting with and split it into two separate files based on negative and positive numbers. What is the command to do so? And then I need to also transfer... (4 Replies)
Discussion started by: cckaiser15
4 Replies

2. UNIX for Beginners Questions & Answers

Converting negative number to positive in a file

Hi ALL, I am having semi column separated file as below. I am having negative values for the records starting with 11095. How can I convert that positive number I tried this below seems not working sed 's/ \(*\)$/ -\1/;t;s/\(.*\)-/\1/ myfile myfile... (6 Replies)
Discussion started by: arunkumar_mca
6 Replies

3. Shell Programming and Scripting

Splitting a file based on positive and negative numbers

Dear All, I have to split a tab delimited file in two files based on the presence of a positive or negative in column number 9 , for example file: A 1 5 erg + 6766 0.9889 0.9817 9.01882 erg inside upstream B 1 8 erg2 + 6766 0.9889 0.9817 -9.22 erg2 inside... (3 Replies)
Discussion started by: paolo.kunder
3 Replies

4. Shell Programming and Scripting

Taking largest (negative) number from column of coordinates and adding positive form to every other

Hello all, I'm new to the forums and hope to be able to contribute something useful in the future; however I must admit that what has prompted me to join is the fact that currently I need help with something that has me at the end of my tether. I have a PDB (Protein Data Bank) file which I... (13 Replies)
Discussion started by: crunchgargoyle
13 Replies

5. Shell Programming and Scripting

Find Where Values Change From Positive To Negative and viceversa

Hi all, I have a file that looks like shown below. I want to find places where the value in column 2 change from negative to positive and vice versa and return the value on column 1 at that point. I wonder if this is possible in shell script or awk .. please help! Here is the original data ... (6 Replies)
Discussion started by: malandisa
6 Replies

6. Shell Programming and Scripting

Sorting positive and negative values

Hello, I have a list like this : 1 2 -4 0 -3 -7 5 6 etc. Is there a way to remove all the positive values and print only the negative values, without using grep, sed or awk? Thanks, Prasanna (4 Replies)
Discussion started by: prasanna1157
4 Replies

7. Shell Programming and Scripting

Finding the most positive and negative value and defining its position

Hi, I have a file that looks like this: Jake 2 3 4 6 4 3 -2 -1 Jerry 1 2 3 2 1 7 -6 -1 Timmy -1 -4 -5 -8 9 3 1 I want to find the most positive and negative value for each row and also define its position (based on column #) So the output would look... (7 Replies)
Discussion started by: gisele_l
7 Replies

8. Shell Programming and Scripting

Perl output with negative and positive numbers

Hello, For my weather station I have made a little perl script to put the data into cacti. The next problem I have. I can only get positive numbers or negative numbers. What do I do: Though a shell scrip I call the perl script. Shell script: #!/bin/sh cat data.txt | stats.pl Perl... (4 Replies)
Discussion started by: rbl-blacklight
4 Replies

9. Shell Programming and Scripting

Help in adding positive & negative values in a column

Hi Gurus, In my file I have an amount field from position 74 to 87, which contains values starting with '+' as well as '-'. I want to add all positive values in a varible called "CREDIT" and all negative values in a variable "DEBIT". I know, we can use grep to identify values with positive and... (4 Replies)
Discussion started by: berlin_germany
4 Replies
Login or Register to Ask a Question