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 302963115 by MOHANP12 on Thursday 24th of December 2015 03:36:54 AM
Old 12-24-2015
awk to sum in Loop
i want code in awk with loop to get the sum

* is delimiter in file

TOTAL_AMOUNT=SUM(CLP04)
suppose there are 12 CLP04 segment in my file i want to add upto 5 CLP04 then print next line after BPR segment after calculate the total amount

CLP04 means
ex
Code:
CLP*0875299*1*13.79*9.83*0*13*8190615108233B~
CLP*CLP01*CLP02*13.79*CLP04*0*13*8190615108233B~ =9.83

Input file:

Code:
BPR*I*TOTAL_AMOUNT*C*CHK************20110916~
LX*1~
TS3*0113528*99*20111231*1*13.79~
CLP*0875299*1*13.79*9.83*0*13*8190615108233B~
CAS*CO*45*3.96~
LX*2~
TS3*0327127*99*20111231*4*835.93~
CLP*0788253*1*657.99*522.76*0*13*8174960108177G~
SVC*N4>00378912498*657.99*522.76**15~
DTM*472*20110817~
CAS*CO*45*135.23~
CLP*0788252*1*126.99*87.6*0*13*8174956108176G~
DTM*472*20110817~
CAS*CO*45*39.39~
CLP*0780207*1*12.06*8.3*0*13*8197106108259G~
DTM*472*20110825~
CAS*CO*45*3.76~
CLP*0778221*1*38.89*37.8*0*13*8195084108256G~
CAS*CO*45*1.09~
LX*3~
TS3*0328511*99*20111231*2*46.28~
CLP*0248208*1*29.29*6.1*0*13*8199996108261G~
CAS*CO*45*23.19~
CLP*0248209*1*16.99*10.75*0*13*8199318108269G~
CAS*CO*45*6.24~
LX*4~
TS3*0714229*99*20111231*1*16.29~
CLP*0435884*1*16.29*8.56*0*13*8170304108160G~
NM1*QC*1*S2AAHUSNV*648BHR3****MI*X18XZ2BBB-TP~
DTM*472*20110825~
CAS*CO*45*3.76~
CLP*0778221*1*38.89*37.8*0*13*8195084108256G~
CAS*CO*45*1.09~
LX*3~
TS3*0328511*99*20111231*2*46.28~
CLP*0248208*1*29.29*6.1*0*13*8199996108261G~
CAS*CO*45*23.19~
CLP*0248209*1*16.99*10.75*0*13*8199318108269G~
CAS*CO*45*6.24~
LX*4~
TS3*0714229*99*20111231*1*16.29~
CLP*0435884*1*16.29*8.56*0*13*8170304108160G~
NM1*QC*1*S2AAHUSNV*648BHR3****MI*X18XZ2BBB-TP~

 

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 DEBIAN

apache2::authcassimple

Apache2::AuthCASSimple(3pm)				User Contributed Perl Documentation			       Apache2::AuthCASSimple(3pm)

NAME

       Apache2::AuthCASSimple - Apache2 module to authentificate through a CAS server

DESCRIPTION

       Apache2::AuthCASSimple is an authentication module for Apache2/mod_perl2. It allow you to authentificate users through a Yale CAS server.
       It means you don't need to give login/password if you've already be authentificate by the CAS server, only tickets are exchanged between
       Web client, Apache2 server and CAS server. If you not're authentificate yet, you'll be redirect on the CAS server login form.

       This module allow the use of simple text files for sessions.

SYNOPSIS

	 PerlOptions +GlobalRequest

	 <Location /protected>
	   AuthType Apache2::AuthCASSimple
	   PerlAuthenHandler Apache2::AuthCASSimple

	   PerlSetVar CASServerName my.casserver.com
	   PerlSetVar CASServerPath /
	   # PerlSetVar CASServerPort 443
	   # PerlSetVar CASServerNoSSL 1
	   PerlSetVar CASSessionTimeout 3660
	   PerlSetVar CASSessionDirectory /tmp
	   # PerlSetVar CASFixDirectory /
	   # PerlSetVar ModProxy 1
	   # PerlSetVar HTTPSServer 1

	   require valid-user
	 </Location>

       or

	 order deny,allow
	 deny from all

	 require user xxx yyyy

	 satisfy any

CONFIGURATION

       CASServerName
	   Name of the CAS server. It can be a numeric IP address.

       CASServerPort
	   Port of the CAS server. Default is 443.

       CASServerPath
	   Path (URI) of the CAS server. Default is "/cas".

       CASServerNoSSL
	   Disable SSL transaction wih CAS server (HTTPS). Default is off.

       CASCaFile
	   CAS server public key. This file is used to allow secure connection between the webserver using Apache2::AuthCASSimple and the CAS
	   server.

	   DEPRECATED : Authen::CAS::Client use LWP::UserAgent to make https requests

       CASSessionTimeout
	   Timeout (in second) for session create by Apache2::AuthCASSimple (to avoid CAS server overloading). Default is 60.

	   -1 means disable.

	   0 mean infinite (until the user close browser).

       CASSessionDirectory
	   Directory where session data are stored. Default is /tmp.

       CASFixDirectory
	   Force the path of the session cookie for same policy in all subdirectories else current directory is used.

       ModProxy
	   Apache2 mod_perl2 don't be use with mod_proxy. Default is off.

       HTTPSServer
	   If you want to keep a HTTPS server for all data. Default is 0.

       OK AUTH_REQUIRED DECLINED REDIRECT SERVER_ERROR M_GET
	   Apache constants to make pod coverage happy

METHOD

   handler
       call by apache2

VERSION

       This documentation describes Apache2::AuthCASSimple version 0.10

BUGS AND TROUBLESHOOTING

       o   Old expired sessions files must be deleted with an example provided script : "delete_session_data.pl"

       o   Apache::Session::Wrapper certainly need Apache2::Cookie

       o   $r must be global for sessions with Apache::Session::Wrapper, add

	     PerlOptions +GlobalRequest

	   in your virtualhost conf

       o   Apreq module must be enable in debian

	     a2enmod apreq

	   or add

	     LoadModule apreq_module /usr/lib/apache2/modules/mod_apreq2.so

	   in your apache configuration file

       Please submit any bug reports to agostini@univ-metz.fr.

NOTES

       Requires "mod_perl 2" version 2.02 or later Requires Authen::CAS::Client Requires Apache::Session::Wrapper

AUTHOR

	   Yves Agostini
	   CPAN ID: YVESAGO
	   Univ Metz
	   agostini@univ-metz.fr
	   http://www.crium.univ-metz.fr

COPYRIGHT

       Copyright (c) 2009 by Yves Agostini

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       The full text of the license can be found in the LICENSE file included with this module.

perl v5.10.0							    2009-05-10					       Apache2::AuthCASSimple(3pm)
All times are GMT -4. The time now is 05:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy