|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
Summation of the column value in an interval.
Post 302317080 by varungupta on Monday 18th of May 2009 04:12:29 AM
05-18-2009
Quote:
In that timespan, i would like to keep the 6 summations togather and then would add them finally.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Please help to share your thought about how to perfrom summation for particular delimited field, and output to the particular file based on
-rw-r--r-- 1 abc other 3094 Oct 19 09:40 0132019832-ps5_online_cdrm.unl
-rw-r--r-- 1 abc other 1588 Oct 19 09:47... (2 Replies)
Discussion started by: rauphelhunter
2 Replies
2. Shell Programming and Scripting
Help plz
Does any one have any idea how to compare interval ranges of 2 files.
finding 1-4 (1,2,3,4) of input2 in input1 of same key "a" values (5-10, 30-40, 45-60, 80-90, 100-120 ). Obviously 1-4 is not one of the range with in input1 a. so it should give out of range.
finding 30-33(31,32,33)... (1 Reply)
Discussion started by: repinementer
1 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I need to sum values in a row.
eg:
input is: sum,value1,value2,value3,.....,value N
Required Output: sum,<summation of N values>
Please help me... (1 Reply)
Discussion started by: MrGopal666
1 Replies
4. Shell Programming and Scripting
Hello everyone,
my data is in a format as below
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a (8 Replies)
Discussion started by: jojo123
8 Replies
5. Shell Programming and Scripting
Hello Guys
Please find my below requirement
I have a flat file with column headers in first line and data
The structure like below
col1 col2 col3
A 1 2
B 3 4
C 5 6
Say I have to take the summation of col2 (that will depend on the... (2 Replies)
Discussion started by: Pratik4891
2 Replies
6. Shell Programming and Scripting
Hello Guru s
I need your kind help to solve my below issue
I have a directory of flat files and have to calculate sum of some columns from the flat file .
Say for flat file 302 I need the column summation of 2 and 3 rd column
For flat file 303 I need the column summation of 5 and... (2 Replies)
Discussion started by: Pratik4891
2 Replies
7. Shell Programming and Scripting
Hi
I am executing below command to do summation on 46th coloumn.
cat File1| awk -F"|" '{p += $46} END { printf"Column Name | SUM | " p}'
I am getting output as
Column Name | SUM | 1.01139e+10
Here I want output in Proper decimal format. Can someone tell me what change is required for same? (1 Reply)
Discussion started by: sanranad
1 Replies
8. Shell Programming and Scripting
hi guys,
i have a script that basically just sums up the values of 2 particular columns in a file, grouped by the columns specified as well
The script is quite long, but it's basically just repetitive.. just for each condition.
This script only accepts one type of input file.
... (22 Replies)
Discussion started by: ramneim
22 Replies
9. Shell Programming and Scripting
I have three folders named f1, f2 and f3. The file names are same in all these folders. I would like to get the summation of the second column from all files. How can I do this ?
file1 in f1 folder
143 143.69 60.2 81.30 40.4 62.39 166.3 83.38 107.2 60.30 37.5
144 192.62 107.9... (3 Replies)
Discussion started by: edisonjoe
3 Replies
10. UNIX for Beginners Questions & Answers
Hi All ,
I am having an input file as stated below
Input file
6 ddk/djhdj/djhdj/Q 10 0.5
dhd/jdjd.djd.nd/QB 01 0.5
hdhd/jd/jd/jdj/Q 10 0.5
512 hd/hdh/gdh/Q 01 0.5
jdjd/jd/ud/j/QB 10 0.5
HD/jsj/djd/Q 01 0.5
71 hdh/jjd/dj/jd/Q 10 0.5
... (5 Replies)
Discussion started by: kshitij
5 Replies
LEARN ABOUT PHP
db2_field_display_size
DB2_FIELD_DISPLAY_SIZE(3) 1 DB2_FIELD_DISPLAY_SIZE(3) db2_field_display_size - Returns the maximum number of bytes required to display a column SYNOPSIS
int db2_field_display_size (resource $stmt, mixed $column) DESCRIPTION
Returns the maximum number of bytes required to display a column in a result set. PARAMETERS
o $stmt - Specifies a statement resource containing a result set. o $column - Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a string containing the name of the column. RETURN VALUES
Returns an integer value with the maximum number of bytes required to display the specified column. If the column does not exist in the result set, db2_field_display_size(3) returns FALSE. SEE ALSO
db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_type(3), db2_field_width(3). PHP Documentation Group DB2_FIELD_DISPLAY_SIZE(3)