Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with awk percentage calculation from a file
Top Forums Shell Programming and Scripting Help with awk percentage calculation from a file Post 302988479 by RavinderSingh13 on Tuesday 27th of December 2016 04:59:03 AM
Old 12-27-2016
Hello venkitesh,

Welcome to forums, could you please try following and let me know if this helps.
Code:
awk '{TOT=$2+0;gsub(/[[:digit:]]|\./,X,$2);USED=$3+0;gsub(/[[:digit:]]|\./,X,$3);if(($2 ~ /GB/ || $2 ~ /TB/)&& TOT>=USED){VAL=USED/TOT * 100};if($2 ~ /TB/ && $3 ~ /GB/ && TOT>=USED){VAL=USED/(TOT * 1024) * 100};if(VAL>20){print $1" filesystem has more disk space used than threshold."};VAL=""}'  Input_file

Output will be as follows.
Code:
/test/test1 filesystem has more disk space used than threshold.

So in above code I have put 20 as threshold, you could set it as per your requirement. I hope this helps(It only handles filesystem capacity in either TBs and GBs).
EDIT: Adding a non-one liner form of solution now too.
Code:
awk '{
        TOT=$2+0;
        gsub(/[[:digit:]]|\./,X,$2);
        USED=$3+0;
        gsub(/[[:digit:]]|\./,X,$3);
        if(($2 ~ /GB/ || $2 ~ /TB/) && TOT>=USED){
                                        VAL=USED/TOT * 100
                                  };
        if($2 ~ /TB/ && $3 ~ /GB/ && TOT>=USED){
                                                VAL=USED/(TOT * 1024) * 100
                                               };
        if(VAL>20){
                        print $1" filesystem has more disk space used than threshold."
                  };
        VAL=""
     }
   '   Input_file

Thanks,
R. Singh
Last edited by RavinderSingh13; 12-28-2016 at 02:25 AM..
This User Gave Thanks to RavinderSingh13 For This Post:
venkitesh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk percentage

how would you calculate percentage by per line? Given a column of 16 lines, grab each line and divide it by the sum of the entire column and multiply by 100? thanks ... (8 Replies)
Discussion started by: rockiefx
8 Replies

2. Shell Programming and Scripting

Need an AWK script to calculate the percentage

Hi I need a awk script to calculate percentage. I have to pass the pararmeters in to the awk script and calculate the percentage. Sum = 50 passed = 43 failed = 7 I need to pass these value in to the awk script and calculate the percentage. Please advice me. (8 Replies)
Discussion started by: bobprabhu
8 Replies

3. Shell Programming and Scripting

awk script to count percentage from log file

Hi, I have a log like this : actually i want to get the log like this : where % can get from : 100 * pmTotNoRrcConnectReqSucc / pmTotNoRrcConnectReq Thanks in advance.. :) (8 Replies)
Discussion started by: justbow
8 Replies

4. Shell Programming and Scripting

File Size calculation with AWK

Hello Friends, Im calculating file sizes with below AWK script. I do this before some spesific files are transferred. I run the script it works but after several running it stuck with a limit of 2147483647 (2 Gbytes -1 byte) and cant exceed this. Something is wrong and I can't proceed, would... (1 Reply)
Discussion started by: EAGL€
1 Replies

5. Shell Programming and Scripting

awk/sed percentage calculation

Hi all i have a text file with columns delimited with , 2010-08-18,10,24,.09751,39,7,14872,26732 . . . i would to add a extra column in the end with percentage calculation of columns 5 and 8 ie (39/26732)*100 so the output must look like ... (6 Replies)
Discussion started by: posner
6 Replies

6. Shell Programming and Scripting

Percentage Calculation in Decimal

Hi, I have two variable and I need to calculate the percentage of them. Example: (b-a)*100/b How can I do it? I need to do it till 2 decimal point. (16 Replies)
Discussion started by: Anupam_Halder
16 Replies

7. Shell Programming and Scripting

Percentage calculation

i am trying to get percentage : but not able to do it: i tried : x=1 y=2 z=`expr $x/$y*100` it is not giving me result can u pls help on this (4 Replies)
Discussion started by: Aditya.Gurgaon
4 Replies

8. Shell Programming and Scripting

find percentage - awk

Please help me with this ... Input file /vol/test1 10G /vol/test2 1G /vol/test3 200G /vol/test4 3G Output File /vol/test1 10G - - 9G - /vol/test2 1024M - - 921M - /vol/test3 200G - - 180G - /vol/test4 3072M - - 2764M - Basically if Column 2 ( which is... (6 Replies)
Discussion started by: greycells
6 Replies

9. Shell Programming and Scripting

Percentage calculation

Hi, I have a text file in below format. I trying to find a solution for finding percentage used for each of the NAMEs. Directory ALLOCATED USED NAME1 93MB 93KB NAME2 25G 62K NAME3 14G 873M NAME4 25G 62K NAME5 20G... (10 Replies)
Discussion started by: ctrld
10 Replies

10. HP-UX

Shell /awk script for Percentage

having two columns, A and B.. i need to add another column C in a file and calculate the percentage based on the column A and B. (COLUMN B/ COLUMN A *100) . "|" is delimiter separating the A and B.. need C column with the percentage value. Thanks for your help 100|50 |50% ... (6 Replies)
Discussion started by: kartikirans
6 Replies

LEARN ABOUT DEBIAN

font::ttf::post

Font::TTF::Post(3pm)					User Contributed Perl Documentation				      Font::TTF::Post(3pm)

NAME

       Font::TTF::Post - Holds the Postscript names for each glyph

DESCRIPTION

       Holds the postscript names for glyphs. Note that they are not held as an array, but as indexes into two lists. The first list is the
       standard Postscript name list defined by the TrueType standard. The second comes from the font directly.

       Looking up a glyph from a Postscript name or a name from a glyph number is achieved through methods rather than variable lookup.

       This class handles PostScript table types of 1, 2, 2.5 & 3, but not version 4.  Support for version 2.5 is as per Apple spec rather than
       MS.

       The way to look up Postscript names or glyphs is:

	   $pname = $f->{'post'}{'VAL'}[$gnum];
	   $gnum = $f->{'post'}{'STRINGS'}{$pname};

INSTANCE VARIABLES

       Due to different systems having different limitations, there are various class variables available to control what post table types can be
       written.

       $Font::TTF::Post::no25
	   If set tells Font::TTF::Post::out to use table type 2 instead of 2.5 in case apps can't handle version 2.5.

       VAL Contains an array indexed by glyph number of Postscript names. This is used when writing out a font.

       STRINGS
	   An associative array of Postscript names mapping to the highest glyph with that name. These may not be in sync with VAL.

       In addition there are the standard introductory variables defined in the standard:

	   FormatType
	   italicAngle
	   underlinePosition
	   underlineThickness
	   isFixedPitch
	   minMemType42
	   maxMemType42
	   minMemType1
	   maxMemType1

METHODS

   $t->read
       Reads the Postscript table into memory from disk

   $t->out($fh)
       Writes out a new Postscript name table from memory or copies from disk

   $t->XML_element($context, $depth, $key, $val)
       Outputs the names as one block of XML

BUGS

       o   No support for type 4 tables

AUTHOR

       Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing.

perl v5.10.1							    2009-01-21						      Font::TTF::Post(3pm)
All times are GMT -4. The time now is 02:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy