Get min from a column

[kichoo]

Hi All,

i am new to scripting

i have a file : file.dat with following data

STORAGE PERCENTAGE FLAG:
/storage_01 64% 0
/storage_02 17% 1
/storage_03 10% 0
/storage_04 50% 1

I need to get the value of STORAGE from those with FLAG=0 and which has the min PERCENTAGE

Please guide me on this..

Thanks in advance

[barriehie]

Hi All,

i am new to scripting

i have a file : file.dat with following data

STORAGE PERCENTAGE FLAG:
/storage_01 64% 0
/storage_02 17% 1
/storage_03 10% 0
/storage_04 50% 1

I need to get the value of STORAGE from those with FLAG=0 and which has the min PERCENTAGE

Please guide me on this..

Thanks in advance

Try this:

gawk '{ if($3~/0$/) { print $3, $2, $1 } }' ./file.dat > ./file.almost && sort -g ./file.almost > ./file.sorted && read < ./file.sorted && echo $REPLY | gawk '{ print $3, $2, $1 }' && rm ./file.almost && rm ./file.sorted

[kichoo]

Hi Barriehie,

thank you so much..

Can you please explain me the code?

I am a newbie here....

thanks a lot

[kichoo]

and also can you let me know how can i get the STORAGE value deried from this in a variable?

[Franklin52]

and also can you let me know how can i get the STORAGE value deried from this in a variable?

storagename=$(awk '
NR==1{min=100;next}
$3==0 && int($2)<min{min=int($2); s=$1}
END{print s}' file)

The solution is also given in this forum:

Get min from a column conditionally - The UNIX and Linux Forums