09-12-2007
Quote:
Originally Posted by
sandeepb
Thanks for reply
The numbers i need to pick up are decided based on certain beginning value
of a comma separated values and only for specific rows in a file, i am able to get these values stripped out in a separate file, only the calcualtion is coming wrong. Say a.txt is a file and following are the contents :
12345678912
123458785454
145645645454
4548778545487
545645
79879878978787878
I am opening this file to perform addition in loop.
Pls. comment
Sandeep
so does the proposed solution work on the the 'a.txt' file or not?
I get a value of '79884709207988830' for the posted sample a.txt
If you do your 'stripping' [no pun inteded] with 'awk', you might be able to do your additions in the same awk script with no need for the intermediate 'stripped' file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Gives me wrong value when,
$ echo `expr 2221753117 + 299363384`
-1773850795
How to overcome this?
Appreciate any help on this.
-Om (5 Replies)
Discussion started by: Omkumar
5 Replies
2. Shell Programming and Scripting
Hi All,
Please help me to perform sum of values in a loop, I am getting following error:
"total=0++432907765772: ++ requires lvalue"
where actual statement is as : total=$total+$amt
where amt can have +ve or -ve values
Thanks
Sandeepb (3 Replies)
Discussion started by: sandeepb
3 Replies
3. UNIX for Dummies Questions & Answers
Trying to do some simple maths on a large file. Excel works fine but I have 1 million entries:
If the difference between a number in column 2 and the one above it is more than 100 the insert a new line
8 4001 4100
8 4101 4200
8 4201 4300
8 15901 16000
8 15910 ... (1 Reply)
Discussion started by: dr_sabz
1 Replies
4. Shell Programming and Scripting
hi,
I have 2 large lists:
LIST A: containes 6 fields of many entries (VARIABLE number), like:
2011-07-10 | 18:19:47 | 38037300 | 9647808003122 | 2 | success
LIST B: containes 3 fields & 183 entries (FIXED number), like:
9647805651885 9647805651885 SCP_10
What I want is a... (8 Replies)
Discussion started by: amurib
8 Replies
5. Shell Programming and Scripting
Hello. I was wondering if anyone could help. I have a file containing a large table in the format:
marker1 marker2 marker3 marker4
position1 position2 position3 position4
genotype1 genotype2 genotype3 genotype4
with marker being a name, position a numeric... (2 Replies)
Discussion started by: davegen
2 Replies
6. Shell Programming and Scripting
Hello All,
Maybe I'm Missing something here but I have NOOO idea what the heck is going on with this....?
I have a Variable that contains a PATTERN of what I'm considering "Illegal Characters". So what I'm doing is looping
through a string containing some of these "Illegal Characters". Now... (5 Replies)
Discussion started by: mrm5102
5 Replies
7. Shell Programming and Scripting
Experts,
When doing large calculation the digits in the screen are limiting to 68 digit and then with a \ ( backspace) next line comes.
example:
ubuntu# echo "123456789 ^ 50 " | bc
37648602365872212683379005814670372328125515868188009630652959693316\... (4 Replies)
Discussion started by: rveri
4 Replies
8. Shell Programming and Scripting
Hi,
I have a large output file (star.log), with many lines of the following type
*** T vavg unburnt: 723.187 / burnt: 2662.000
What I would like to do is pick the values 723.187 and 2662.000 and
What I've got so far is
awk '/unburnt:.*burnt:/{Tu=$6;Tb=$NF}END{print Tu, Tb}'... (6 Replies)
Discussion started by: lost.identity
6 Replies
9. Shell Programming and Scripting
Here's my code:
awk -F '' 'NR==FNR {
if (/time/ && $5>10)
A=$2" "$3":"$4":"($5-01)
else if (/time/ && $5<01)
A=$2" "$3":"$4-01":"(59-$5)
else if (/time/ && $5<=10)
A=$2" "$3":"$4":0"($5-01)
else if (/close/) {
B=0
n1=n2;
... (2 Replies)
Discussion started by: klane
2 Replies
10. Shell Programming and Scripting
Hi i have some large data files that contain several fields and rows the data in a field have a numeric value that is in a sine wave pattern what i would like todo is locate each peak and pick the highest value and print that complete line. the data looks something like this it is field nr4 which... (4 Replies)
Discussion started by: ninjaunx
4 Replies
LEARN ABOUT DEBIAN
numsum
NUMSUM(1) User Contributed Perl Documentation NUMSUM(1)
NAME
numsum - numsum program file
SYNOPSIS
numsum [-iIcdhrsvxy] <FILE>
| numsum [-iIcdhrsvxy] (Input on STDIN from pipeline.)
numsum [-iIcdhrsvxy] (Input on STDIN. Use Ctrl-D to stop.)
DESCRIPTION
numsum will take all the numbers on stdin and return the sum of those numbers. Currently it only processes the first number on each line.
Besides positive numbers, it also handles negative numbers and numbers with decimals.
OPTIONS
-i Only return the integer portion of the final sum.
-I Only return the decimal portion of the final sum.
-c Print out the sum of each column.
-r Print out the sum of each row.
-x <n> Specify a comma seperated list of columns to print.
-y <n> Specify a comma seperated list of rows to print.
-s <string> Specify a string to use as a seperator for columns.
This defaults to be consecutive whitespace (s+).
-h Help: You're looking at it.
-V Increase verbosity.
-d Debug mode. For developers
-q Quiet mode, don't print any warnings.
EXAMPLES
Simply add up the numbers in a file.
$ numsum numbers.txt
4315
Enter your own numbers on STDIN. The last number is the answer.
$ numsum
4
21
98
100
223
Use it in a command pipeline.
$ ls -1s | grep .mp3 | numsum -c -x 5
72288
Add up the total byte count in a http log file.
$ cat access_log | awk {'print $10'} numsum
or
numsum -c -x 10 access_log
Add up the columns of numbers of a file.
$ cat columns
1 6 11 16 21
2 7 12 17 22
3 8 13 18 23
4 9 14 19 24
5 10 15 20 25
$ numsum -c columns
15 40 65 90 115
Add up the 1st, 2nd and 5th columns only.
$ numsum -c -x 1,2,5 columns
15 40 115
Add up the rows of numbers of a file.
$ numsum -r columns
55
60
65
70
75
Add up the 2nd and 4th rows.
$ numsum -r -y 2,4 columns
60
70
SEE ALSO
numaverage(1), numbound(1), numinterval(1), numnormalize(1), numgrep(1), numprocess(1), numrandom(1), numrange(1), numround(1)
COPYRIGHT
numsum is part of the num-utils package, which is copyrighted by Suso Banderas and released under the GPL license. Please read the COPYING
and LICENSE files that came with the num-utils package
Developers can read the GOALS file and contact me about providing
submitions or help for the project.
MORE INFO
More info on numsum can be found at:
http://suso.suso.org/programs/num-utils/
perl v5.10.1 2009-10-31 NUMSUM(1)