Re: matching column variables from two awks!

On 3/23/2008 4:04 PM, Rajan wrote:

[please don't top-post, fixed below]

> "spacegoose" <spacegoose@[EMAIL PROTECTED]
> wrote in message 
>
news:8acca503-5eaf-4d95-abca-c8fd6390f99c@[EMAIL PROTECTED]
> 
>>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 
> 
> you can do this with a combination of sort and paste but if you are a
gawky 
> like me
> 
> BEGIN{
> cmd="df -h | grep whatever | sort -n +5"
> while(cmd | getline)
> { mntspace[$1]=$2;mntused[$1]=$3}
> cmd="awk {'print $5'} myFile |sort |uniq -c |sort -nr"
> while(cmd|getline)
> {mntacs[$2]=$1}
> printf "%-12s %-12s %-12s %-12s", "Disk", "Space", "Used", "Accounts"
> for (each1 in mntspace) {printf "%-12s %-12s %-12s %-12s", each1, 
> mntspace[each1], mntused[each1], mntacs[each1]}
> exit
> }
> 

I don't mean to be rude, but the above is missing the point of awk as a
text-processing tool and trying to force it to behave like a shell, i.e.
an
environment for invoking tools. It's totally the wrong approach to solving
this
or any other problem.

	Ed.