Sponsored Content
Top Forums Shell Programming and Scripting How to put a difference calculation in my awk script ? Post 303037058 by Tim2424 on Monday 22nd of July 2019 02:19:33 PM
Old 07-22-2019
How to put a difference calculation in my awk script ?

Hello,

For my CGI, I have this script :
Code:
#!/bin/bash


echo "Content-type: text/html"
echo ""

echo '
<html>
        <head>
                <meta http-equiv="Content-Type" content="test/html"; charset=UTF-8">
                <title> CLF MONITORING </title>
                <h1> FRAME monitoring <font size=3> <a href="Index.sh">[ Index ]</a> </font> </h1>
                <hr size="4" color="blue">
                
        <style>
                         body{
                          background-color: #eff1f0;
                         }
        </style>

        </head>
<body>'

read a
test=$( echo $a | cut -d'=' -f2)

echo '<PRE>'

echo "FRAME : $test "
echo "------------------"

echo ""

for fn in /var/www/cgi-bin/LPAR_MAP/*; do awk -F',|;' 'NR==1 { split(FILENAME ,a,"[-.]");print "DATE ========================== : " a[4] }
/'$test'/ { 

print ""
print "LPARS :" $2
print "RAM : " $5
print "CPU 1 : " $6
print "CPU 2 : " $7
print "" 
print ""}' $fn; done

echo '</PRE>'

echo '</body>
</html>'

This script allow to display informations from CSV like this :

Code:
FRAME : MIAIBYF00
---------------------------------


DATE ========================== : 20180122

LPARS : miaibv189
RAM : 4
CPU 1 : 0.1
CPU 2 : 0.1

LPARS : miaibp05
RAM : 61
CPU 1 : 1.1
CPU 2 : 3


LPARS : miaibp05
RAM : 61
CPU 1 : 1.1
CPU 2 : 3


DATE ========================== : 20180123

LPARS : miaibv189
RAM : 7
CPU 1 : 0.5
CPU 2 : 0.5

LPARS : miaibp05
RAM : 59
CPU 1 : 1.0 
CPU 2 : 3 


LPARS : miaibp05
RAM : 61
CPU 1 : 1.1
CPU 2 : 3

I would like to display the consumption diffenence between theses to date next to the good informations. Something like :

FRAME : MIAIBYF00
---------------------------------


DATE ========================== : 20180122

LPARS : miaibv189
RAM : 4
CPU 1 : 0.1

CPU 2 : 0.1

LPARS : miaibp05
RAM : 61
CPU 1 : 1.1
CPU 2 : 3


LPARS : miaibp05
RAM : 61
CPU 1 : 1.1
CPU 2 : 3


DATE ========================== : 20180123

LPARS : miaibv189
RAM : 7 ( + 3 )
CPU 1 : 0.5 ( + 0.4 )
CPU 2 : 0.5 ( + 0.4 )

LPARS : miaibp05
RAM : 59 ( - 2 )
CPU 1 : 1.0 ( - 0.1 )
CPU 2 : 3 


LPARS : miaibp05
RAM : 61
CPU 1 : 1.1
CPU 2 : 3

But I don't know how to do this... Can you help me ?


Thank yor ! Smilie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Time difference calculation

Hi Team, I am currently in the process of writing a script which will take a filename in the format SKADEV.0.db2.NODE0000.CATN0000.20080714231015.001 where the sixth string(with "." as the seperator) is the time stamp of the time of creation of the file. now here is my issue . I need to be... (2 Replies)
Discussion started by: Segwar
2 Replies

2. Shell Programming and Scripting

Put the difference of two files in out file

Hello, I have two files file1 & file2 containing both lines (1 word per line). I need to extract the lines that are in file1 and not present in file2 and have the result in output file. i.e : user>cat file1 line1 line2 line3 line4 line5 user>cat file2 line1 line3 line5 The... (2 Replies)
Discussion started by: newpromo
2 Replies

3. Shell Programming and Scripting

calculation using awk or shell script in between the numbers

file A E969K D223L E400L E34L file B predicted 3 1 250 251 500 501 1000 The output should be E969K 501 1000 D223L 1 250 E400L 251 500 E34L 1 250 I tried in this way (1 Reply)
Discussion started by: cdfd123
1 Replies

4. Shell Programming and Scripting

AWK Script and Commandline difference

Hey there, I just stumbled upon a difference between using awk on the commandline and using it in a shellscript. I have a variable, e.g.: PROG=vim then i want to check if the package with this name is installed: TEMPVAL=$(dpkg -l | awk '{ if ($2 == "$PROG") print $2 }') (Im using... (10 Replies)
Discussion started by: MrSnail
10 Replies

5. Shell Programming and Scripting

Compare two CSV files and put the difference in third file with line no,field no and diff value.

I am having two csv files i need to compare these files and the output file should have the information of the differences at the field level. For Example, File 1: A,B,C,D,E,F 1,2,3,4,5,6 File 2: A,C,B,D,E,F 1,2,4,5,5,6 out put file: (12 Replies)
Discussion started by: karingulanagara
12 Replies

6. Shell Programming and Scripting

awk script - redirecting out put based on mapping

Need awk solution. Please advise. inputfile.txt 1,NY, 1111 2,MI, 222 3,NY,333 4,OH,444 5,OH,555 mapping.txt NY NYNY IL ILLINOIS OH OHIO Need to write a code which will compare 2nd column of inputfile.txt with mapping file and redirect output based on the... (2 Replies)
Discussion started by: vegasluxor
2 Replies

7. UNIX for Dummies Questions & Answers

Shell script - getting Time difference using awk

Hi..I have the data in a file like in this format, and I need the output time difference in seconds by using awk command. Start date/time and end date/time given in column 2,3 & 4,5. Please assist how to write shell script. File1.txt JOB1 10/09/2013 17:42:16 10/09/2013 17:43:46 SU 6202685/1... (4 Replies)
Discussion started by: mprithvi
4 Replies

8. Shell Programming and Scripting

awk script to find time difference between HTTP PUT and HTTP DELETE requests in access.log

Hi, I'm trying to write a script to determine the time gap between HTTP PUT and HTTP DELETE requests in the HTTP Servers access log. Normally client will do HTTP PUT to push content e.g. file_1.txt and 21 seconds later it will do HTTP DELETE, but sometimes the time varies causing some issues... (3 Replies)
Discussion started by: Juha
3 Replies

9. Shell Programming and Scripting

awk to calculate difference of split and sum the difference

In the awk I am trying to subtract the difference $3-$2 of each matching $4 before the first _ (underscore) and print that value in $13. I think the awk will do that, but added comments. What I am not sure off is how to add a line or lines that will add sum each matching $13 value and put it in... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. Shell Programming and Scripting

How to put the command to remove duplicate lines in my awk script?

I create a CGI in bash/html. My awk script looks like : echo "<table>" for fn in /var/www/cgi-bin/LPAR_MAP/*; do echo "<td>" echo "<PRE>" awk -F',|;' -v test="$test" ' NR==1 { split(FILENAME ,a,""); } $0 ~ test { if(!header++){ ... (12 Replies)
Discussion started by: Tim2424
12 Replies
CGI::FormBuilder::Template::CGI_SSI(3pm)		User Contributed Perl Documentation		  CGI::FormBuilder::Template::CGI_SSI(3pm)

NAME
CGI::FormBuilder::Template::CGI_SSI - FormBuilder interface to CGI::SSI SYNOPSIS
my $form = CGI::FormBuilder->new( fields => @fields, template => { type => 'CGI_SSI', file => "template.html", }, ); DESCRIPTION
This engine adapts FormBuilder to use "CGI::SSI". You can specify any options which "CGI::SSI->new" accepts by using a hashref: my $form = CGI::FormBuilder->new( fields => @fields, template => { type => 'CGI::SSI', file => 'form.shtml', sizefmt => 'abbrev' } ); In addition to CGI::SSI new arguments, you can also specify "file", "virtual", or "string" argument. The following methods are provided (usually only used internally): engine Returns a reference to the "CGI::SSI" object prepare Returns a hash of all the fields ready to be rendered. render Uses the prepared hash and expands the template, returning a string of HTML. TEMPLATES
In your template, each of the form fields will correspond directly to a "<!--#echo -->" of the same name prefixed with "field-" in the template. So, if you defined a field called "email", then you would setup a variable called "<!--#echo var="field-email" -->" in your template. In addition, there are a couple special fields: <!--#echo var="js-head" --> - JavaScript to stick in <head> <!--#echo var="form-title" --> - The <title> of the HTML form <!--#echo var="form-start" --> - Opening <form> tag and internal fields <!--#echo var="form-submit" --> - The submit button(s) <!--#echo var="form-reset" --> - The reset button <!--#echo var="form-end" --> - Just the closing </form> tag Let's look at an example "form.html" template we could use: <html> <head> <title>User Information</title> <!--#echo var="js-head" --><!-- this holds the JavaScript code --> </head> <!--#echo var="form-start" --><!-- this holds the initial form tag --> <h3>User Information</h3> Please fill out the following information: <!-- each of these <!--#echo -->'s corresponds to a field --> <p>Your full name: <!--#echo var="field-name" --> <p>Your email address: <!--#echo var="field-email" --> <p>Choose a password: <!--#echo var="field-password" --> <p>Please confirm it: <!--#echo var="field-confirm_password--> <p>Your home zipcode: <!--#echo var="field-zipcode --> <p> <!--#echo var="form-submit" --><!-- this holds the form submit button --> </form><!-- can also use "tmpl_var form-end", same thing --> As you see, you get a "<!--#echo -->" for each for field you define. However, you may want even more control. That is, maybe you want to specify every nitty-gritty detail of your input fields, and just want this module to take care of the statefulness of the values. This is no problem, since this module also provides several other "<tmpl_var>" tags as well: <!--#echo var="value-[field] --> - The value of a given field <!--#echo var="label-[field] --> - The human-readable label <!--#echo var="comment-[field] --> - Any optional comment <!--#echo var="error-[field] --> - Error text if validation fails <!--#echo var="required-[field] --> - See if the field is required This means you could say something like this in your template: <!--#echo var="label-email" -->: <input type="text" name="email" value="<!--#echo var="value-email" -->"> <font size="-1"><i><!--#echo var="error-email" --></i></font> And FormBuilder would take care of the value stickiness for you, while you have control over the specifics of the "<input>" tag. A sample expansion may create HTML like the following: Email: <input type="text" name="email" value="nate@wiger.org"> <font size="-1"><i>You must enter a valid value</i></font> Note, though, that this will only get the first value in the case of a multi-value parameter (for example, a multi-select list). Multiple values (loops) in "CGI_SSI" are not yet implemented. For more information on templates, see HTML::Template. SEE ALSO
CGI::FormBuilder, CGI::FormBuilder::Template, HTML::Template REVISION
$Id: HTML.pm 97 2007-02-06 17:10:39Z nwiger $ AUTHOR
Copyright (c) Nate Wiger <http://nateware.com>. All Rights Reserved. This module is free software; you may copy this under the terms of the GNU General Public License, or the Artistic License, copies of which should have accompanied your Perl kit. perl v5.14.2 2011-09-16 CGI::FormBuilder::Template::CGI_SSI(3pm)
All times are GMT -4. The time now is 08:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy