Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [Solved] Find Specific records from file and add totals into variables
Top Forums Shell Programming and Scripting [Solved] Find Specific records from file and add totals into variables Post 302341255 by danmero on Wednesday 5th of August 2009 10:47:44 AM
Old 08-05-2009
Quote:
Originally Posted by veeru
Out Put Should be like this

Total Records Sent: 100+200+300 = 600
Total Sum : 10+20+30 = 60
Base on your data sample
Code:
# awk '/Records Sent/{a[$1FS$2]+=$3;b[$4]+=$5}END{for(i in a)print v,i,a[i];for(i in b)print v,i,b[i]}' v="Total" file
Total Records Sent: 600
Total Sum1: 60

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extarct specific records from wide file

I have a file which is 5 million records. And each records has 412 fields has delimited by "|". So that makes each records to be 2923 bytes long. I wanted to extract specific records like top 100 or 2500 - 5000, 50001 - 10000 etc. from this file. I tried using head command for top 100 records,... (1 Reply)
Discussion started by: acheepi
1 Replies

2. Shell Programming and Scripting

cut specific records from a file

I am trying to cut the first 10 characters from a file only if the file has 'xyz' in field 185-188. I tried this cat filename | cut -c1-10 but this gives me all the records regardless of what is in field 185-188. Is this doable ? Thanks in advance for responses. (2 Replies)
Discussion started by: jxh461
2 Replies

3. UNIX for Dummies Questions & Answers

Cut specific fields from a file containing multiline records

Hi, I am looking for a method to get column13 to column 50 data from the 1st line of a multiline reord. The records are stored in a large file and are separated by newline. sample format is (data in red is to be extracted) <header> A001dfhskhfkdsh hajfhksdhfjh... (3 Replies)
Discussion started by: sunayana3112
3 Replies

4. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that... (4 Replies)
Discussion started by: Atrisa
4 Replies

5. Shell Programming and Scripting

[Solved] Find duplicate and add pattern in sed/awk

<Update> I have the solution: sed 's/\{3\}/&;&;---;4/' The thread can be marked as solved! </Update> Hi There, I'm working on a script processing some data from a website into cvs format. There is only one final problem left I can't find a solution. I've processed my file... (0 Replies)
Discussion started by: lolworlds
0 Replies

6. Shell Programming and Scripting

Extract error records based on specific criteria from Unix file

Hi, I look for a awk one liner for below issue. input file ABC 1234 abc 12345 ABC 4567 678 XYZ xyz ght 678 ABC 787 yyuu ABC 789 7890 777 zxr hyip hyu mno uii 678 776 ABC ty7 888 All lines should be started with ABC as first field. If a record has another value for 1st... (7 Replies)
Discussion started by: ratheesh2011
7 Replies

7. Shell Programming and Scripting

[Solved] Working with date (add minutes using variables)

Dear all, today I'm scratching my head with a simple (I believe) issue. Working with date is quite simple, so if I Need to add some seconds to current time, I'll use: date --date='+30 seconds' +"%Y-%m-%d %H:%M:%S"But, how to pass the value to add from a variable? I tried the following without... (2 Replies)
Discussion started by: Lord Spectre
2 Replies

8. Shell Programming and Scripting

[SOLVED] nawk FS using pipe read variables from file

I have a file data_1.out which contains: 1|abc mail|mail subject|mail body 2|def mail|mail subject|def mail body I am trying to read the variables from data_1.out and use them to print to 2 different files based on the id (first_column) The problem is I am not able to read the file... (8 Replies)
Discussion started by: sol_nov
8 Replies

9. Shell Programming and Scripting

[Solved] How to print specific text from a file?

Hi All, I have the below text file from which I have to cut particular section starting from PTR_Security_Rpeorting.cpf to PTR_Security_Reporting_Env93_export. Report Model............: "D:\Cognos_Publishing\tmp.a2R94KLQec"\PTR_Security_Reporting.cpf Report Output Script....:... (4 Replies)
Discussion started by: Vikram_Tanwar12
4 Replies

10. UNIX for Beginners Questions & Answers

Find records with specific characters in 2 nd field

Hi , I have a requirement to read a file ( 5 fields , ~ delimited) and find the records which contain anything other than Alphabets, Numbers , comma ,space and dot . ie a-z and A-Z and 0-9 and . and " " and , in 2nd field. Once I do that i would want the result to have field1|<flag> flag can... (2 Replies)
Discussion started by: ashwin3086
2 Replies

LEARN ABOUT OPENSOLARIS

n2cp

n2cp(7d)							      Devices								  n2cp(7d)

NAME

       n2cp - Ultra-SPARC T2 crypto provider device driver

DESCRIPTION

       The  n2cp  device  driver  is a multi-threaded, loadable hardware driver supporting hardware-assisted acceleration of the following crypto-
       graphic operations, which are built into the Ultra-SPARC T2 CMT processor:

	 DES:	CKM_DES_CBC, CKM_DES_ECB
	 DES3:	CKM_DES3_CBC, CKM_DES3_ECB,
	 AES:	CKM_AES_CBC, CKM_AES_ECB, CKM_AES_CTR, CKM_AES_CCM, CKM_AES_GCM
	 RC4:	CKM_RC4
	 MD5:	KM_MD5, CKM_MD5_HMAC, CKM_MD5_HMAC_GENERAL,
		  CKM_SSL3_MD5_MAC
	 SHA-1: CKM_SHA_1, CKM_SHA_1_HMAC,
		 CKM_SHA_1_HMAC_GENERAL, CKM_SSL3_SHA1_MAC
	 SHA-256:CKM_SHA256, CKM_SHA256_HMAC,
		 CKM_SHA256_HMAC_GENERAL

CONFIGURATION

       You configure the n2cp driver by defining properties in the /kernel/drv/n2cp.conf which override the default settings. The following  prop-
       erty is supported:

       nostats			   Disables the generation of statistics.  The nostats property may be used to help prevent traffic analysis, how-
				   ever, this may inhibit support personnel.

CRYPTO STATISTICS

       Solaris crypto drivers must implement statistics variables. The n2cp driver maintains the following statistics:

       cwqXstate		   State (online, offline, error) of respective cryptographic engine, CWQ X.

       cwqXsubmit		   Number of jobs submitted to CWQ X.

       cwqXqfull		   Number of times when submitting a job that the queue for CWQ X was full.

       cwqXqupdate_failure	   Number of submit job failures on CWQ X.

       des			   Total number of jobs submitted to device for DES operations.

       des3			   Total number of jobs submitted to device for DES3 operations.

       aes			   Total number of jobs submitted to device for AES operations.

       md5			   Total number of jobs submitted to device for MD5 operations.

       sha1			   Total number of jobs submitted to device for SHA-1 operations.

       sha256			   Total number of jobs submitted to device for SHA-256 operations.

       md5hmac			   Total number of jobs submitted to device for HMAC_MD5 operations.

       sha1hmac 		   Total number of jobs submitted to device for HMAC_SHA-1 operations.

       sha256hmac		   Total number of jobs submitted to device for HMAC_SHA-256 operations.

       ssl3md5mac		   Total number of jobs submitted to device for SSL3_MAC_MD5 operations.

       ssl3sha1mac		   Total number of jobs submitted to device for SSL3_MAC_SHA-1 operations.

       ssl3sha256mac		   Total number of jobs submitted to device for SSL3_MAC_SHA-256 operations.

       Note -

	 Additional statistics targeted for Sun support personnel are not documented in this manpage.

FILES

       /kernel/drv/sparcv9/n2cp

	   64-bit ELF kernel driver.

       /platform/sun4v/kernel/drv/n2cp.conf

	   Configuration file.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Architecture		     |SPARC			   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWn2cp.v		   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Unstable			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       elfsign(1), cryptoadm(1M), kstat(1M), libpkcs11(3LIB), printers.conf(4), pkcs11_kernel(5), attributes(5)

       Solaris Cryptographic Framework - Solaris Software Developer Collection

       Solaris Security for Developer's Guide - Solaris Software Developer Collection

SunOS 5.11							    13 Jan 2009 							  n2cp(7d)
All times are GMT -4. The time now is 03:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy