Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk to sum in Loop
Contact Us Post Here to Contact Site Administrators and Moderators awk to sum in Loop Post 302963145 by MOHANP12 on Thursday 24th of December 2015 10:57:14 AM
Old 12-24-2015
My OS is AIX 7 and ksh shell

Input data

Code:
ISA*00*          *00*          *ZZ*ABCCOM         *ZZ*99999999       *040315*1005*U*00401*004075123*0*P*:
GS*HP*ABCCOM*01017*20110315*1005*1*X*004010X091A1
ST*835*07504123
BPR*H*5.75*C*NON************20110315
CLP*999999*4*25.95*0*25.95*13*0000000555555555*11
CAS*CR*18*25.95*0
REF*6R*999999
CLP*888888*4*162.13*0*162.13*MC*0000000456789123*11
SVC*ZZ:M151000:F0*162.13*0**1.9
DTM*472*20020920
CAS*CO*29*162.13*0*42*0*0
CLP*111111*2*56.52*18.88*0*13*0000000644444444*53
CLP*121212*4*56.52*0*0*13*0000000646464640*53
CLP*333333*1*74.61*59.69*14.92*13*0000000688888888*55
REF*6R*333333
CLP*777777*25*136.9*0*0*13*0000000622222222*53
DTM*472*20030911
CAS*PI*104*136.72*0
CAS*CO*42*0.18*0
NM1*82*2*ABTHSOLUTE HELP*****FI*346608640
REF*F8*A76B04054
SVC*HC:H0004:HF:H9*-86.76*-86.76**-4
DTM*472*20110210
CAS*CR*22*0*0*42*0*0
CAS*OA*22*0*0
REF*6R*090909
LQ*HE*MA92
SE*93*07504123
GE*1*1
IEA*1*004075123


Output File



ISA*00*          *00*          *ZZ*ABCCOM         *ZZ*99999999       *040315*1005*U*00401*004075123*0*P*:
GS*HP*ABCCOM*01017*20110315*1005*1*X*004010X091A1
ST*835*07504123
BPR*H*5.75*C*NON************20110315
CLP*999999*4*25.95*0*25.95*13*0000000555555555*11
CAS*CR*18*25.95*0
REF*6R*999999
CLP*888888*4*162.13*0*162.13*MC*0000000456789123*11
SVC*ZZ:M151000:F0*162.13*0**1.9
DTM*472*20020920
CAS*CO*29*162.13*0*42*0*0
CLP*111111*2*56.52*18.88*0*13*0000000644444444*53
SE*93*07504123
ST*835*07504123
BPR*H*5.75*C*NON************20110315
CLP*121212*4*56.52*0*0*13*0000000646464640*53
CLP*333333*1*74.61*59.69*14.92*13*0000000688888888*55
REF*6R*333333
CLP*777777*25*136.9*0*0*13*0000000622222222*53
DTM*472*20030911
CAS*PI*104*136.72*0
CAS*CO*42*0.18*0
NM1*82*2*ABTHSOLUTE HELP*****FI*346608640
REF*F8*A76B04054
SVC*HC:H0004:HF:H9*-86.76*-86.76**-4
DTM*472*20110210
CAS*CR*22*0*0*42*0*0
CAS*OA*22*0*0
REF*6R*090909
LQ*HE*MA92
SE*93*07504123
GE*1*1
IEA*1*004075123

Thanks in advance

Don CLP04 means input file have number of rows in which row which start with CLP and * is field separator then value after 4th * is CLP 04
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

While loop - The sum seems to be local

Hi, I am trying to extracting the sum of all varibles listed in a file. The code is as follows ##### FILE1 ######## Value1:2 Value2:2 Value3:6 Value4:5 ##### shell script ###### #!/bin/sh total=0 (2 Replies)
Discussion started by: eagercyber
2 Replies

2. Shell Programming and Scripting

Sum with awk

Hi,consider this fields, $1 $2 $3 981 0 1 984 0 4 985 1 0 987 0 2 990 0 0 993 0 3 995 2 0 996 0 1 999 0 4 for each occurence of zero in column $2 and $3 I need to sum $1 fields, so for example, in this piece of code the result of $1 is 8910. I'm sure... (2 Replies)
Discussion started by: cv313x
2 Replies

3. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Hi Experts, I am adding a column of numbers with awk , however not getting correct output: # awk '{sum+=$1} END {print sum}' datafile 2.15291e+06 How can I getthe output like : 2152910 Thank you.. # awk '{sum+=$1} END {print sum}' datafile 2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies

4. Shell Programming and Scripting

Sum using awk

Hi all, I need to sum values for fields in a delimited file as below: 2010-03-05||| 2010-03-05|||123 2010-03-05|467.621|369.532| 2010-03-06||| 2010-03-06||2| 2010-03-06|||444 2010-03-07||| 2010-03-07||| 2010-03-07|655.456|1019.301| Code used is: nawk -F "|" ' { sum +=... (7 Replies)
Discussion started by: Katabatic
7 Replies

5. Shell Programming and Scripting

loop + sum + print using awk

Hi, I am unable sum of each column in the loop usng awk command. Awk is not allowing the parameters in the command. i am facing the below error. awk: 0602-562 Field $() is not correct. Source file abc.txt 100,200,300,400,500,600,700,800,900 101,201,301,401,501,601,701,801,901 ... (1 Reply)
Discussion started by: number10
1 Replies

6. Shell Programming and Scripting

Loop through file to sum conditionally

Hi, I have a file with header, detail and trailer records. HDR|111 DTL|abc|100|xyz DTL|abc|50|xyz TRL|150 I need to add the values in 3rd field from DTL records. Using awk, I am doing it as follows: awk -F'|' '$1=="DTL"{a += $3} END {print a}' <source_file> However, I want to... (3 Replies)
Discussion started by: delta21
3 Replies

7. Shell Programming and Scripting

For Loop & SUM

pcmpath query device |awk 'BEGIN{print "DEVICE NAME\tSERIAL"} /DEVICE NAME/ {printf "%s\t", $5; getline; print substr($2, length($2)-3)}' This script returns output like below to pull out "DEVICE NAME SERIAL". ...... hdisk28 110B hdisk29 1112 hdisk30 1115 hdisk31 1116 hdisk32 1128... (2 Replies)
Discussion started by: Daniel Gate
2 Replies

8. Shell Programming and Scripting

Sum up numbers in a for loop

Hi i have to calculate some numbers, column by column. Herfore i used a for-loop.. for i in {4..26};do awk -F"," '{x'$i'+=$'$i'}END{print '$i'"\t" x'$i'}' file.tmp;done ----- printout ----- 4 660905240 5 71205272 6 8.26169e+07 7 8.85961e+07 8 8.60936e+07 9 7.42238e+07 10 5.6051e+07... (7 Replies)
Discussion started by: IMPe
7 Replies

9. Shell Programming and Scripting

Need help the sum from loop

Hi all, I have one host i need to run in loop to check the capacity from different frame and get the output to one file and sum it and convert to TB this is Code #!/bin/ksh DATE=`date '+%d%m%y'` for f in `cat /home/esx-capacity/esx-host.txt` do for g in `cat /home/esx-capacity/frame`... (10 Replies)
Discussion started by: ranjancom2000
10 Replies

LEARN ABOUT OPENSOLARIS

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

ATTRIBUTES

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

       +--------------------+-----------------+
       |  ATTRIBUTE TYPE    | ATTRIBUTE VALUE |
       +--------------------+-----------------+
       |Availability	    | SUNWgawk	      |
       +--------------------+-----------------+
       |Interface Stability | Volatile	      |
       +--------------------+-----------------+
NOTES

       Source for gawk is available on http://opensolaris.org.

Free Software Foundation					    Nov 3 1999								  IGAWK(1)
All times are GMT -4. The time now is 12:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy