I have a text file in below format.
I trying to find a solution for finding percentage used for each of the NAMEs.
I tried several awk solution like
but none worked due to the different formats like KB,MB,GB ,TB.
Is there anyway i can do it one line ? Also I may not be able to recalculate the data in one format.
Your code implied that your input file uses | as the field separator, but your sample input uses whitespace as the input field separator and you didn't show us any sample output. The following code uses whitespace as the input field separator and | as the output field separator. And, I still see lots of "human readable" values that don't end with B. The following code seems to do what you want (treating KB and K, MB and M, ... as synonyms). I greatly prefer readable to 1-liner, but as with any awk program you can convert it to a single line if you want to...
As always, if you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
With your sample input plus the following line added to the end:
it produces the output:
and exits with exit code 1. When run with just your sample input, the last three lines shown above are not printed and it exits with exit code 0.
Last edited by Don Cragun; 10-21-2015 at 03:07 PM..
Reason: Fix typo: s/codet/code/
This User Gave Thanks to Don Cragun For This Post:
If you need only row number and the percentage then following may help you in same.
Output will be as follows. EDIT: Adding a non one-liner form of solution for same now.
Thanks,
R. Singh
Last edited by RavinderSingh13; 10-21-2015 at 01:45 PM..
Reason: Added a non one-liner form of solution now
This User Gave Thanks to RavinderSingh13 For This Post:
If you need only row number and the percentage then following may help you in same.
... ... ...
Hi Ravinder,
Nice script.
Note, however, that the line shown in red (which occurs a few times in your script isn't needed and can't be executed. Commands in a code block following a return command will never be reached.
These 2 Users Gave Thanks to Don Cragun For This Post:
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)
Hello,
Ive got a bunch of numbers here e.g:
6065
6094
6348
6297
6161
6377
6338
6290
How do I find out if there is a difference between 10% or more between one of these numbers ? I am trying to do this in Bash.. but no luck so far.. Does anyone have an Idea ??
Thanx,
- Pascal... (9 Replies)
Hi,
I am looking for generic commands / scripts that could run across platforms especially on HP Itanium boxes to give me % of free OS parameters
For eg:
Free Total Memory RAM : 20 %
Free Total Swap Memory: 35%
Free Total CPU utilisation: 44%
Free Disk Space: /appl = 55%... (5 Replies)
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)
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)
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)
i have 3 files like
total.dat=18
equal.dat=14
notequal.dat=16
i need find the equal percentange means:
equalpercentage = ($equal.dat / $total.dat * 100)
How i can do this ?
I tried some of the answers to calculate the percentage in this forums.but it couldn't worked.Some one please... (6 Replies)
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)
hi, I am new to awk.. and getting used to the scripts. I have a small data set 5 coulms.. 16 rows.
1) I am trying to remove the percentages of each line of colum 3..like first line divided the sum of colum 3 divided by 100 and print it out. removing hte percentages of each line
I would really... (3 Replies)