Re: matching column variables from two awks!

On 3/20/2008 11:36 PM, spacegoose wrote:
> i have a program that prints out a formatted df command
> by sorting and grepping and using awk to print it out.
> 
> it basically executes df -h | grep whatever | sort -n +5 and then
> awks
> to a nice printout like:
> 
> disk size capacity
> ------------------
> foo	20gb	70%
> moo	40gb	25%
> bar	20gb	70%
> 
> i'd like to add a new column "accounts" to this print out.
> 
> the no. of accounts is derived from a command:
> awk {'print $5'} myFile |sort |uniq -c |sort -nr
> 
> which prints rows like:
> 
> 450 	foo
> 300	moo
> 104	bar
> 
> i want to integrate this command into the formatted df program's
> output.
> i can't figure out how to appropriately append the "account count"
> column from the myFile command, to the appropriate row of the
> formatted df output,
> e.g. where col 1 from the formatted df output matches col 2 of the
> myFile command.
> 
> so it looks like this:
> 
> 
> disk size capacity accounts
> ---------------------------
> foo	20gb	70%	450
> moo	40gb	25%	300
> bar	20gb	70%	104
> 
> 
> Thanks for any hints!
> sg

$ cat file1
450     foo
300     moo
104     bar

$ cat file2
disk size capacity
------------------
foo     20gb    70%
moo     40gb    25%
bar     20gb    70%

$ awk '
NR==FNR{acct[$2]=$1;next} FNR==1{sfx=" account"} FNR==2{sfx="--------"}
FNR>2{sfx=" "acct[$1]} {print $0 sfx}' file1 file2
disk size capacity account
--------------------------
foo     20gb    70% 450
moo     40gb    25% 300
bar     20gb    70% 104

but I expect there's a much simpler way to get your desired output using
awk on
your raw output rather than doing all that post-processing with other
tools
first. If you provide your "df -h" output and "myFile" contents that got
you the
data above, we could probably help.

	Ed.