awk and sum with original data


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk and sum with original data
# 1  
Old 10-25-2018
awk and sum with original data

I am using the

Code:
cat /home/billing/1|awk '{ SUM += $8} END { print SUM }' >> /home/billing/test

I am getting the only total of the all i need to print with all details

Source File

Code:
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134B TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134C TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A4 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A5 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A6 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A7 TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00215 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00216 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00217 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00218 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00219 RDF1+TDEV 151451

I need output has below
Code:
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134B TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134C TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A4 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A5 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A6 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A7 TDEV 151451
Total =908706

All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00215 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00216 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00217 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00218 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00219 RDF1+TDEV 151451
Total=757255

# 2  
Old 10-25-2018
what's the key for each group/block?
# 3  
Old 10-25-2018
The key will be server name. for each server i need to total
# 4  
Old 10-25-2018
Code:
sort -k4,4 myFile | awk '$4!=p {if(p) print "Total= " tot;p=$4;tot=0} {print;tot+=$NF} END {print "Total= " tot}'

This User Gave Thanks to vgersh99 For This Post:
# 5  
Old 10-25-2018
Quote:
Originally Posted by vgersh99
Code:
sort -k4,4 myFile | awk '$4!=p {if(p) print "Total= " tot;p=$4;tot=0} {print;tot+=$NF} END {print "Total= " tot}'

thanks working fine
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Need Optimization shell/awk script to aggreagte (sum) for all the columns of Huge data file

Optimization shell/awk script to aggregate (sum) for all the columns of Huge data file File delimiter "|" Need to have Sum of all columns, with column number : aggregation (summation) for each column File not having the header Like below - Column 1 "Total Column 2 : "Total ... ...... (2 Replies)
Discussion started by: kartikirans
2 Replies

2. Shell Programming and Scripting

Help with sum range of data set together

Input File: 2000 3 1998 2 1997 2 1994 1 1991 1 1989 1 1987 2 1986 2 1985 1 1984 1 . . 10 277256 9 278274 8 282507 7 284837 6 287066 5 292967 (4 Replies)
Discussion started by: perl_beginner
4 Replies

3. Shell Programming and Scripting

Help with sum of data set

Input file 2 1159,310, 4 142,199,218,91, 3 91,273,349, Desired output result 2 1469 4 650 3 713 I have long list of input file as shown above. It has a "," delimited to separate between each record in column 2.... (1 Reply)
Discussion started by: perl_beginner
1 Replies

4. Shell Programming and Scripting

AWK print and retain original format

I have a file with very specific column spacing formatting, I wish to do the following: awk '{print $1, $2, $3, $4, $5, $6, $19-$7, $20-$8, $21-$9, $10, $11, $12}' merge.pdb > vector.pdb but the format gets ruined. I have tried with print -f but to no avail.... (7 Replies)
Discussion started by: chrisjorg
7 Replies

5. Shell Programming and Scripting

Help with calculate total sum of same data problem

Long list of input file: AGDRE1 0.1005449050 AGDRE1 2.1005443435 AGDRE1 1.2005449050 AGDRE1 5.1005487870 AASFV3 50.456304789 AASFV3 2.3659706549 AASFV3 6.3489807860 AASFV3 3.0089890148 RTRTRS 5.6546403546 . . Desired output file: AGDRE1 8.5021829410 AASFV3 62.180245240... (2 Replies)
Discussion started by: perl_beginner
2 Replies

6. UNIX for Dummies Questions & Answers

Sum of data in row format

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

7. UNIX for Advanced & Expert Users

A variable and sum of its value in a huge data.

Hi Experts, I got a question.. In the following output of `ps -elf | grep DataFlow` I get:- 242001 A mqsiadm 2076676 1691742 0 60 20 26ad4f400 130164 * May 09 - 3:02 DataFlowEngine EAIDVBR1_BROKER 5e453de8-2001-0000-0080-fd142b9ce8cb VIPS_INQ1 0 242001 A mqsiadm... (5 Replies)
Discussion started by: varungupta
5 Replies

8. Shell Programming and Scripting

Identify matching data in a file and output to original line, in perl

Hi, I haven't done this for awhile, and further, I've never done it in perl so I appreciate any help you can give me. I have a file of lines, each with 5 data points that look like this: AB,N,ALLIANCEBERNSTEIN HLDNG L.P,AB,N ALD,N,ALLIED CAPITAL CORPORATION,ALD,N AFC,N,ALLIED CAPITAL... (4 Replies)
Discussion started by: Pcushing
4 Replies

9. Shell Programming and Scripting

Read the data from multiple files and sum the value

Hi all, I have a requirement where i have to read multiple files using Shell Script in Korn Shell. each file will have the 3rd line as the amount field, i have to read this amount field and sum it for all the files. any idea on how to achieve this?? (i think i can achieve it using a loop,... (9 Replies)
Discussion started by: nvuradi
9 Replies
Login or Register to Ask a Question