Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help the sum from loop
Top Forums Shell Programming and Scripting Need help the sum from loop Post 302998172 by ranjancom2000 on Friday 26th of May 2017 01:04:54 PM
Old 05-26-2017
where i need to copy this code

Code:
awk '{a[$2]+=$NF} ; END {for (i in a) print i " = " a[i]}' Report

---------- Post updated at 12:04 PM ---------- Previous update was at 11:59 AM ----------

Still it is blank only. FYI i am running this from my CYGWIN console

Code:
#!/bin/ksh
DATE=`date '+%d%m%y'`
while read f
do
   tr ',' '\n' < /home/esx-capacity/frame | while read g
   do
      echo "$g:::$f"
      symaccess -sid $g  list devinfo -ig $f 
   done |awk '{a[$2]+=$NF} ; END {for (i in a) print i " = " a[i]}' 
done < /home/esx-capacity/esx-host.txt > /home/esx-capacity/Report

 

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

Using variables created sequentially in a loop while still inside of the loop [bash]

I'm trying to understand if it's possible to create a set of variables that are numbered based on another variable (using eval) in a loop, and then call on it before the loop ends. As an example I've written a script called question (The fist command is to show what is the contents of the... (2 Replies)
Discussion started by: DeCoTwc
2 Replies

3. Shell Programming and Scripting

Print sum and relative value of the sum

Hi i data looks like this: student 1 Subject1 45 55 Subject2 44 55 Subject3 33 44 // student 2 Subject1 45 55 Subject2 44 55 Subject3 33 44 i would like to sum $2, $3 (marks) and divide each entry in $2 and $3 with their respective sums and print for each student as $4 and... (2 Replies)
Discussion started by: saint2006
2 Replies

4. 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

5. 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

6. 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

7. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ... (2 Replies)
Discussion started by: klane
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. Post Here to Contact Site Administrators and Moderators

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 ... (5 Replies)
Discussion started by: MOHANP12
5 Replies

LEARN ABOUT DEBIAN

loop

loop(6x)							XScreenSaver manual							  loop(6x)

NAME

       loop - cellular automaton.

SYNOPSIS

       loop  [-display	host:display.screen]  [-visual visual] [-window] [-root] [-cycles number] [-delay number] [-ncolors number] [-size number]
       [-fps]

DESCRIPTION

       Another cellular automaton.  This one produces loop-shaped colonies that spawn, age, and eventually die.

OPTIONS

       -visual visual
	       Specify which visual to use.  Legal values are the name of a visual class, or the id number (decimal or hex) of a specific visual.

       -window Draw on a newly-created window.	This is the default.

       -root   Draw on the root window.

       -cycles number
	       Timeout.  0 - 8000.  Default: 1600.

       -delay number
	       Per-frame delay, in microseconds.  Default: 100000 (0.10 seconds.).

       -ncolors number
	       Number of Colors.  Default: 15.

       -size number
	       Size.  -50 - 50.  Default: -12.

       -fps    Display the current frame rate and CPU load.

ENVIRONMENT

       DISPLAY to get the default host and display number.

       XENVIRONMENT
	       to get the name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property.

SEE ALSO

       X(1), xscreensaver(1)

COPYRIGHT

       Copyright (C) 2002 by David Bagley.  Permission to use, copy, modify, distribute, and sell this software and its documentation for any pur-
       pose  is  hereby granted without fee, provided that the above copyright notice appear in all copies and that both that copyright notice and
       this permission notice appear in supporting documentation.  No representations are made about the suitability of this software for any pur-
       pose.  It is provided "as is" without express or implied warranty.

AUTHOR

       David Bagley.

X Version 11							5.15 (28-Sep-2011)							  loop(6x)
All times are GMT -4. The time now is 01:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy