Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Calculate the total 4 field based on the conditions
Top Forums Shell Programming and Scripting Calculate the total 4 field based on the conditions Post 302959461 by kalia4u on Tuesday 3rd of November 2015 04:38:29 AM
Old 11-03-2015
1.Please remove the only the Grand total record logic in the script Trying to remove the logic but getting error.
Script is displaying right output for Total and ACNO Total(ACNO wise) (please use OFMT because it is floating numbers) .
2.Am new in awk programming .Could you please explain little bit about this script.
Code:
Output-----
ACNO|NAME|TOWN|VAL1|VAL2|VAL3|VAL4
1000|ADU|CAN|10|20|30|40
1000|ADU|CAN|10|20|30|40
Total       |20|40|60|80
1000|NADU|CAN|10|20|30|40
1000|NADU|CAN|10|20|30|40
Total        |20|40|60|80
ACNO Total   |40|80|120|160
1001|AND|NAC|40|50|40|50
1001|AND|NAC|20|70|20|10
Total       |60|120|60|60
1001|PAND|NAC|40|50|40|50
1001|PAND|NAC|20|70|20|10
Total        |60|120|60|60
ACNO Total   |120|240|120|120
1005|ANDP|ACN|20|50|10|30
1005|ANDP|ACN|20|10|30|40
Total        |40|60|40|70
ACNO Total   |40|60|40|70

Last edited by kalia4u; 11-03-2015 at 07:21 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk script to calculate total

Hi First field is the Record Type. A Record Type 5 can have multiple Record Type 6's before another Record Type 5 appears. I want to calculate the total of fields at position 8-11 on Record type 6 when Record Type 5 has a field at position 11-14 equals to '2222'. then it should delete the lines... (2 Replies)
Discussion started by: appsguy616
2 Replies

2. Shell Programming and Scripting

Calculate total sum from a file

The file content is dynamic and using this format: name1 number1 name2 number2 name3 number3 name4 number4 .................... Need a smooth way to calculate the sum of all the numbers in that file (number1 + number2 + number3 + number4........ = total ) (11 Replies)
Discussion started by: TehOne
11 Replies

3. Shell Programming and Scripting

Calculate total space, total used space and total free space in filesystem names matching keyword

Good afternoon! Im new at scripting and Im trying to write a script to calculate total space, total used space and total free space in filesystem names matching a keyword (in this one we will use keyword virginia). Please dont be mean or harsh, like I said Im new and trying my best. Scripting... (4 Replies)
Discussion started by: bigben1220
4 Replies

4. Shell Programming and Scripting

Extract file records based on some field conditions

Hello Friends, I have a file(InputFile.csv) with the following columns(the columns are pipe-delimited): ColA|ColB|ColC|ColD|ColE|ColF Now for this file, I have to get those records which fulfil the following condition: If "ColB" is NOT NULL and "ColD" has values one of the following... (9 Replies)
Discussion started by: mehimadri
9 Replies

5. Shell Programming and Scripting

Adding total of first field for each number in the second field

Dears, I need a script or command which can find the unique number from the second filed and against that number it adds the total of first field . 17215630 , 0 907043 ,1 201050 ,10 394149 ,4 1964 ,9 17215630, 0 907043 ,1 201050, 10 394149 ,4 1964 ,9 1234234, 55 23 ,100 33 ,67 ... (2 Replies)
Discussion started by: shary
2 Replies

6. Shell Programming and Scripting

Calculate total value from a row

HI I have a file # cat marks.txt MARKS LIST 2013 Name english french chinese latin total_marks wer 34 45 67 23 wqa 12 39 10 56 wsy 23 90 23 78 Now i need to find the total marks of each student using... (11 Replies)
Discussion started by: Priya Amaresh
11 Replies

7. Shell Programming and Scripting

Calculate the total

Hi All , I have the following script as below , I tried to modify to meet the requirement , could someone help ? very thanks ================================================================================================ while read STR NAME; do Total=0 MyString="$STR" GetData () {... (18 Replies)
Discussion started by: ust3
18 Replies

8. Shell Programming and Scripting

awk to calculate total and percent off field in file

Trying to use awk to print the lines in file that have either REF or SNV in $3, add a header line, sort by $4 in numerical order. The below code does that already, but where I am stuck is on the last part where the total lines are counted and printed under Total_Targets, under Targets_less_than is... (4 Replies)
Discussion started by: cmccabe
4 Replies

9. Shell Programming and Scripting

awk to assign points to variables based on conditions and update specific field

I have been reading old posts and trying to come up with a solution for the below: Use a tab-delimited input file to assign point to variables that are used to update a specific field, Rank. I really couldn't find too much in the way of assigning points to variable, but made an attempt at an awk... (4 Replies)
Discussion started by: cmccabe
4 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 04:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy