find percentage - awk

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting find percentage - awk
# 1  
Old 09-28-2013
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 in GB's) is less then 10 , convert into MB ( x 1024) and calculate its 90% value ( rounded off) and add it to column 5 , also change G's into M's ... for column 2 which is greater than 10 ... just calculate 90% of it and add it to column 5 as it is

# 2  
Old 09-28-2013
awk '{x=$2;sub("G$","",x)}x<10{printf ("%s %dM - - %dM -\n",$1,x*1024,x*1024*0.9)}x>=10{printf ("%s %dG - - %dG -\n",$1,x,x*0.9)}' file

# 3  
Old 09-28-2013
Thanks Bartus ..but i get this output

PHP Code:
/vol/test1 10G - - 9G -
vol/test2 1024M - - 921M -
vol/test3 200G - - 180G -
vol/test4 3G - - 2G 
3G was not converted to MB as 3 < 10

# 4  
Old 09-28-2013
Post output of:
cat -ev file

# 5  
Old 09-28-2013
/vol/test1 10G$
/vol/test2      1G$
/vol/test3      200G$
/vol/test4 3G$

# 6  
Old 09-28-2013
Hmmm, I noticed some weird behavior of "nawk" in Solaris that seem to be what you are also encountering. To fix it try this:
awk '{x=$2;sub("G$","",x);x*=1}x<10{printf ("%s %dM - - %dM -\n",$1,x*1024,x*1024*0.9)}x>=10{printf ("%s %dG - - %dG -\n",$1,x,x*0.9)}' file

# 7  
Old 09-28-2013
Nice ...Thanks ! I was testing it on Solaris ... it works now ....
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

Help with awk percentage calculation from a file

i have a file say test with the below mentioned details Folder Name Total space Space used /test/test1 500.1GB 112.0 GB /test/test2 3.2 TB 5TB /test/test3 3TB 100GB i need to calculate percentage of each row based on total space and space used and copy... (9 Replies)
Discussion started by: venkitesh
9 Replies

3. Shell Programming and Scripting

Percentage sign causing awk problems

looks like awk gets confused when there's a % next to a number. command im running: awk -F" " '/phxnaz001b/ && /vol/ && NF { if (($NF >= 80) && ($NF < 83)) { print ; print ; w++ } else if ($NF >= 83) { print ; c++ } } END { printf("%d:OK %d:WARNING %d:CRITICAL\n", o, w, c) }' /tmp/test.log ... (3 Replies)
Discussion started by: SkySmart
3 Replies

4. Programming

Shell script to find Percentage?

Hi all, I havea log of data.log bear,10000,white bear,5000,black chicken,2000,white chicken,4000,yellow chicken,3000,black lion,6000,yellow lion,1000,white How can we have shell script to get the percentage of each animals? Thanks. (8 Replies)
Discussion started by: sabercats
8 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

awk or sed to determine battery percentage

So, I know this can be done but my awk and sed wizardry is not up to snuff for the job. Basically, I have tons and tons of Macbooks at my work and I am trying to grab the current percentage of the battery power on each client. If I use the system_profiler SPPowerDataType command it prints off... (4 Replies)
Discussion started by: tlarkin
4 Replies

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

8. Shell Programming and Scripting

Need to find the percentage of the directory in the file system.

Hi All, I want to find the percentage occupied by the directory in the file system. Say, i have the file system /home/arun/work under this file system i have the directories /home/arun/work/yesterday /home/arun/work/today /home/arun/work/tomorrow The size of the file system is... (5 Replies)
Discussion started by: Arunprasad
5 Replies

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

10. 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
Login or Register to Ask a Question