Sponsored Content
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
RSA_sign_ASN1_OCTET_STRING(3)					      OpenSSL					     RSA_sign_ASN1_OCTET_STRING(3)

NAME
RSA_sign_ASN1_OCTET_STRING, RSA_verify_ASN1_OCTET_STRING - RSA signatures SYNOPSIS
#include <openssl/rsa.h> int RSA_sign_ASN1_OCTET_STRING(int dummy, unsigned char *m, unsigned int m_len, unsigned char *sigret, unsigned int *siglen, RSA *rsa); int RSA_verify_ASN1_OCTET_STRING(int dummy, unsigned char *m, unsigned int m_len, unsigned char *sigbuf, unsigned int siglen, RSA *rsa); DESCRIPTION
RSA_sign_ASN1_OCTET_STRING() signs the octet string m of size m_len using the private key rsa represented in DER using PKCS #1 padding. It stores the signature in sigret and the signature size in siglen. sigret must point to RSA_size(rsa) bytes of memory. dummy is ignored. The random number generator must be seeded prior to calling RSA_sign_ASN1_OCTET_STRING(). RSA_verify_ASN1_OCTET_STRING() verifies that the signature sigbuf of size siglen is the DER representation of a given octet string m of size m_len. dummy is ignored. rsa is the signer's public key. RETURN VALUES
RSA_sign_ASN1_OCTET_STRING() returns 1 on success, 0 otherwise. RSA_verify_ASN1_OCTET_STRING() returns 1 on successful verification, 0 otherwise. The error codes can be obtained by ERR_get_error(3). BUGS
These functions serve no recognizable purpose. SEE ALSO
ERR_get_error(3), objects(3), rand(3), rsa(3), RSA_sign(3), RSA_verify(3) HISTORY
RSA_sign_ASN1_OCTET_STRING() and RSA_verify_ASN1_OCTET_STRING() were added in SSLeay 0.8. 0.9.7a 2002-09-25 RSA_sign_ASN1_OCTET_STRING(3)
All times are GMT -4. The time now is 12:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy