Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk and sum with original data
Top Forums Shell Programming and Scripting awk and sum with original data Post 303025162 by ranjancom2000 on Thursday 25th of October 2018 11:58:11 AM
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

 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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

LEARN ABOUT OPENDARWIN

bootparams

BOOTPARAMS(5)                                                 BSD File Formats Manual                                                BOOTPARAMS(5)

NAME

     bootparams -- boot parameter database

SYNOPSIS

     /etc/bootparams

DESCRIPTION

     The bootparams file specifies the boot parameters that diskless clients may request when booting over the network.  Each client supported by
     this server must have an entry in the bootparams file containing the pathnames for its root and (optionally) swap areas.

     Each line in the file (other than comment lines that begin with a #) specifies the client name followed by the pathnames that the client may
     request by their logical names.  The components of the line are delimited with blank or tab, and may be continued onto multiple lines with a
     backslash.

     For example:

           dummy   root=host:/export/dummy/root 
                   swap=host:/export/dummy/swap 
                   dump=host:/export/dummy/swap

     When the client named "dummy" requests the pathname for its logical "root" it will be given the pathname ``host:/export/dummy/root'' as the
     response to its RPC request.  The "host:" component must be supplied.

FILES

     /etc/bootparams  default configuration file

SEE ALSO

     bootparamd(8)

Linux NetKit (0.17)                                               October 2, 1994                                              Linux NetKit (0.17)
All times are GMT -4. The time now is 11:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy