02-12-2010
Hi ,
You can use the below code for your required output.
echo "sum,5,4,3,0" | awk -F"," 'BEGIN {OFS=","} { for(i=2;i<NF+1;i++) x=x+$i ; print "sum",x}'
~ Jash
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I have some numbers in two different files
file1
4.21927E+00 4.68257E+00 5.56871E+00 3.59490E+01 7.65806E+01 1.39827E+02
and
file2
5.61142E+00 6.21648E+00 7.40152E+00 4.41917E+01 8.31586E+01 1.42938E+02
I would like to get file3
which contains in each column the sum of the... (6 Replies)
Discussion started by: f_o_555
6 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. UNIX for Dummies Questions & Answers
Hello,
I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file
Name m/c usage
abc xxx 10
abc xxx 20
abc xxx 5
xyz ... (6 Replies)
Discussion started by: asjaiswal
6 Replies
5. Shell Programming and Scripting
I have the input file in attached.
I want the output file :
Date , Time , Max_Bearer
11/01/2013 , 23:00 , 1447.894167
11/02/2013 , 00:00 , 1429.266667
11/03/2013 , 00:00 , 712.3175
11/04/2013 , 22:00 , 650.9533333
11/05/2013 , 23:00 , 665.9558333
11/06/2013 , 23:00 , 659.8616667... (2 Replies)
Discussion started by: justbow
2 Replies
6. Shell Programming and Scripting
Hello out there,
file.txt:
comp51820_c1_seq1 42 N 0:0:0:0:0:0 1:0:0:0:0:0 0:0:0:0:0:0 3:0:0:0:0:0 0:0:0:0:0:0
comp51820_c1_seq1 43 N 0:0:0:0:0:0 0:1:0:0:0:0 0:0:0:0:0:0 0:3:0:0:0:0 0:0:0:0:0:0
comp51820_c1_seq1 44 N 0:0:4:0:3:1 0:0:1:9:0:0 10:0:0:0:0:0 0:3:3:2:2:6 2:2:2:5:60:3... (16 Replies)
Discussion started by: pathunkathunk
16 Replies
7. UNIX for Dummies Questions & Answers
Hi would like to ask you guys any advise regarding my problem
I have this kind of data
file.txt
111111111,20
111111111,50
222222222,70
333333333,40
444444444,10
444444444,20
I need to get this
file1.txt
111111111,70
222222222,70
333333333,40
444444444,30
using this code I can... (6 Replies)
Discussion started by: reks
6 Replies
8. Shell Programming and Scripting
Hi,
I am a new bie i need some help with respect to shell onliner;
I have data in following format
Name FromDate UntilDate Active Changed Touched
Test 28-03-2013 28-03-2013 1 0.6667 100
Test2 28-03-2013 03-04-2013 ... (1 Reply)
Discussion started by: gangaraju6
1 Replies
9. Shell Programming and Scripting
Need help in coding:
File with several rows incl. numbers like
1 2 3 4
5 6 7 8
...
How can i build the sum of each row seperately?
10
26
...
Thx for help.
Please use CODE tags as required by forum rules! (13 Replies)
Discussion started by: smitty11
13 Replies
10. UNIX for Beginners Questions & Answers
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
math(n) Tcl Math Library math(n)
NAME
math - Tcl Math Library
SYNOPSIS
package require Tcl 8.2
package require math ?1.2?
::math::cov value value ?value ...?
::math::integrate list of xy value pairs
::math::fibonacci n
::math::max value ?value ...?
::math::mean value ?value ...?
::math::min value ?value ...?
::math::prod value ?value ...?
::math::random ?value1? ?value2?
::math::sigma value value ?value ...?
::math::stats value value ?value ...?
::math::sum value ?value ...?
DESCRIPTION
The math package provides utility math functions.
COMMANDS
::math::cov value value ?value ...?
Return the coefficient of variation expressed as percent of two or more numeric values.
::math::integrate list of xy value pairs
Return the area under a "curve" defined by a set of x,y pairs and the error bound as a list.
::math::fibonacci n
Return the n'th Fibonacci number.
::math::max value ?value ...?
Return the maximum of one or more numeric values.
::math::mean value ?value ...?
Return the mean, or "average" of one or more numeric values.
::math::min value ?value ...?
Return the minimum of one or more numeric values.
::math::prod value ?value ...?
Return the product of one or more numeric values.
::math::random ?value1? ?value2?
Return a random number. If no arguments are given, the number is a floating point value between 0 and 1. If one argument is given,
the number is an integer value between 0 and value1. If two arguments are given, the number is an integer value between value1 and
value2.
::math::sigma value value ?value ...?
Return the population standard deviation of two or more numeric values.
::math::stats value value ?value ...?
Return the mean, standard deviation, and coefficient of variation as percent as a list.
::math::sum value ?value ...?
Return the sum of one or more numeric values.
KEYWORDS
math, statistics
math 4.2 math(n)