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 302963160 by Don Cragun on Thursday 24th of December 2015 03:04:36 PM
Old 12-24-2015
And how does adding the three lines:
Code:
SE*93*07504123
ST*835*07504123
BPR*H*5.75*C*NON************20110315

after the 3rd CLP line in your input file relate to your requirements?

Why after 3 CLP lines (instead of after 5)?

The sum of the CLP04 values on those three CLP lines (0+0+18.88) is 18.88. Where is that shown in those three added lines?

I still do not understand what you're trying to do.
 

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 CENTOS

clp

CLP(1)							      General Commands Manual							    CLP(1)

NAME

       clp - linear program solver

SYNOPSIS

       clp filename [ options ] solutionfile

DESCRIPTION

       This manual page documents briefly the clp command.

       clp -- interface to the coin linear programming solver. clp solves the following linear optimization program:

	   minimize	 c^t x
	   such that:	 row_lb <= Ax <= row_ub
			 column_lb <= x <= column_ub

OPTIONS

       When  no options are given clp enters the interactive command line mode.  Otherwise the program enters a batch mode, for which a summary of
       options is included below.  For a complete description, see /usr/share/doc/coinor-libclp-doc.

       -help  Show summary of options.

       -primalsimplex
	      solve the problem using the primal simplex method

       -dualsimplex
	      solve the problem using the dual simplex method

       -maximize
	      maximize the problem

SEE ALSO

       glpsol(1),dsdp5(1)

       This program is fully documented in the accompanying html documentation which can  be  found  in  /usr/share/doc/coinor-libclp-doc  if  the
       coinor-libclp-doc package is installed.

AUTHOR

       clp was written by John J. Forrest <jjforre@us.ibm.com> et.al.

       This manual page was written by Soeren Sonnenburg <sonne@debian.org>, for the Debian project (but may be used by others).

								   May	7, 2008 							    CLP(1)
All times are GMT -4. The time now is 07:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy