Sum function


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Sum function
# 1  
Old 01-16-2014
Sum function

I have file input

Code:
China,Gaolian,9135774346294,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,165
India,Gangga,9135770291502,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3325
India,Nahdit,9135766545904,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,440
India,Kathman,9135768476591,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
China,Liong,9135779924879,AirAsia,0,0,0,0,0,0,0,0,0,0,7000,0,0,0,0
China,Jongy,9135778222275,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,245
Korea,Seoul,9135769911459,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100
India,Gangga,9135777596759,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
India,Hindus,913577679859,AirAsia,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

I need to sum column 5 till column 19, expected output below

Code:
China,Gaolian,9.13577E+12,AirAsia,165
India,Gangga,9.13577E+12,AirAsia,3325
India,Nahdit,9.13577E+12,AirAsia,440
India,Kathman,9.13577E+12,AirAsia,0
China,Liong,9.13578E+12,AirAsia,7000
China,Jongy,9.13578E+12,AirAsia,245
Korea,Seoul,9.13577E+12,AirAsia,100
India,Gangga,9.13578E+12,AirAsia,0
India,Hindus,9.13578E+11,AirAsia,0

Thanks
# 2  
Old 01-16-2014
Hi, that seems pretty straight forward.. What have you tried?
# 3  
Old 01-16-2014
i've tried this
Code:
cat fileinput | nawk '{FS=","; OFS=","; print $1,$2,$3,$4,sum[$5+$6+$7+$8+$9+$10+$11+$12+$13+$14+$15+$16+$17+$18+$19]}'

but it always zero on the fifth column
# 4  
Old 01-16-2014
Hi, FS needs to be set before the main part, also you need a loop to sum the fields. e.g.:
Code:
awk '{s=0; for(i=5; i<=NF; i++) s+=$i; print $1,$2,$3,$4,s}' FS=, OFS=, file

This User Gave Thanks to Scrutinizer For This Post:
# 5  
Old 01-16-2014
big thanks

I still confuse about the statement s=0
Could you please explain more about your code
# 6  
Old 01-16-2014
Hi, s means "sum". The sum is set to zero before the field $5..$NF (last field) values are added by the for loop, for every line of the input file.
This User Gave Thanks to Scrutinizer For This Post:
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Function - Make your function return an exit status

Hi All, Good Day, seeking for your assistance on how to not perform my 2nd, 3rd,4th etc.. function if my 1st function is in else condition. #Body function1() { if then echo "exist" else echo "not exist" } #if not exist in function1 my all other function will not proceed.... (4 Replies)
Discussion started by: meister29
4 Replies

2. Shell Programming and Scripting

Need help on awk for printing the function name inside each function

Hi, I am having script which contains many functions. Need to print each function name at the starting of the function. Like below, functionname() { echo "functionname" commands.... } I've tried like below, func=`grep "()" scriptname | cut -d "(" -f1` for i in $func do nawk -v... (4 Replies)
Discussion started by: Sumanthsv
4 Replies

3. Shell Programming and Scripting

Will files, creaetd in one function of the same script will be recognized in another function?

Dear All. I have a script, which process files one by one. In the script I have two functions. one sftp files to different server the other from existing file create file with different name. My question is: Will sftp function recognize files names , which are created in another... (1 Reply)
Discussion started by: digioleg54
1 Replies

4. Shell Programming and Scripting

Help to Modify File Name in each function before calling another function.

I have a script which does gunzip, zip and untar. Input to the script is file name and file directory (where file is located) I am reading the input parameters as follows: FILENAME=$1 FILEDIR=$2 I have created 3 functions that are as follows: 1) gunzip file 2) unzip file... (2 Replies)
Discussion started by: pinnacle
2 Replies

5. Programming

How to step in one function after the function be executed in gdb?

In gdb, I can call one function with command "call", but how can I step in the function? I don't want to restart the program, but the function had been executed, gdb will execute next statement, and I don't know how to recall the function. (4 Replies)
Discussion started by: 915086731
4 Replies

6. Shell Programming and Scripting

[SOLVED] Awk one line to sum up a function

I need help with debugging an error in my awk script. I have a shell script with variable named U_new_i and want to pass it to awk for use in a summation. The original file have the following content. cat test.txt -2445.7132000000 -2444.9349000000 -2444.3295000000 -2443.1814000000 ... (0 Replies)
Discussion started by: Quantum_Dot
0 Replies

7. Shell Programming and Scripting

Print sum and relative value of the sum

Hi i data looks like this: student 1 Subject1 45 55 Subject2 44 55 Subject3 33 44 // student 2 Subject1 45 55 Subject2 44 55 Subject3 33 44 i would like to sum $2, $3 (marks) and divide each entry in $2 and $3 with their respective sums and print for each student as $4 and... (2 Replies)
Discussion started by: saint2006
2 Replies

8. Shell Programming and Scripting

Return a value from called function to the calling function

I have two scripts. script1.sh looks -------------------------------- #!/bin/bash display() { echo "Welcome to Unix" } display ----------------------------- Script2.sh #!/bin/bash sh script1.sh //simply calling script1.sh ------------------------------ (1 Reply)
Discussion started by: mvictorvijayan
1 Replies

9. Shell Programming and Scripting

Function SUM SIZE

Dear Friends, I wrote a script that get the size of specific files in a specific space directory. To get the total size I wrote a function in that script. So far I am not convinced that function is working correctly. Do you mind tell if there is anything wrong. I am on SOLARIS (KSH)... (4 Replies)
Discussion started by: Aswex
4 Replies

10. Shell Programming and Scripting

Passing global variable to a function which is called by another function

Hi , I have three funcions f1, f2 and f3 . f1 calls f2 and f2 calls f3 . I have a global variable "period" which i want to pass to f3 . Can i pass the variable directly in the definition of f3 ? Pls help . sars (4 Replies)
Discussion started by: sars
4 Replies
Login or Register to Ask a Question

Featured Tech Videos