Re: matching column variables from two awks!

xxx@[EMAIL PROTECTED]
 df -h | grep dsk | sort +5

/dev/md/ds/dsk/x20   200G   129G    69G    66%    /local/ds/xp20
/dev/md/ds/dsk/x21   200G   135G    63G    69%    /local/ds/xp21
/dev/md/ds/dsk/x22   200G   148G    50G    75%    /local/ds/xp22
/dev/md/ds/dsk/x23   200G   128G    70G    65%    /local/ds/xp23
/dev/md/ds/dsk/x24   200G   126G    72G    64%    /local/ds/xp24
/dev/md/ds/dsk/x25   200G   136G    62G    69%    /local/ds/xp25
/dev/md/ds/dsk/x26   200G   129G    69G    66%    /local/ds/xp26
/dev/md/ds/dsk/x27   200G   130G    68G    66%    /local/ds/xp27


xxx@[EMAIL PROTECTED]
 df
/local/ds/xp26(/dev/md/ds/dsk/x26):148445868 blocks 22517420 files
/local/ds/xp12(/dev/md/ds/dsk/x12):144276990 blocks 22608345 files
/local/ds/xp30(/dev/md/ds/dsk/x30):133775594 blocks 22412624 files
/local/ds/xp6 (/dev/md/ds/dsk/x6):121057960 blocks 22383983 files
/local/ds/xp4 (/dev/md/ds/dsk/x4):129103034 blocks 22193600 files



my program foo:

df -h | grep dsk | sort +5 | awk '

BEGIN {
printf("%-30s%12s%12s%12s%10s\n\n", "File System", "bytes", "used",
"available", "capacity")
printf("------------------------------------------------------------------------------
\n")
}

{
        printf("%-30s%12s%12s%12s%10s\n", $6, $2, $3, $4, $5)
}


END {
}'


xxx@[EMAIL PROTECTED]
 ./foo

File System                          bytes        used   available
capacity

------------------------------------------------------------------------------
/global/ds/xp0                    200G        139G         59G
71%
/global/ds/xp1                    200G        131G         67G
66%
/global/ds/xp10                   200G        129G         69G
66%
/global/ds/xp11                   200G        133G         65G
68%
/global/ds/xp12                   200G        131G         67G
67%
/global/ds/xp13                   200G        139G         59G
71%
/global/ds/xp14                   200G        139G         59G
71%
/global/ds/xp15                   200G        132G         66G
67%
/global/ds/xp16                   200G        138G         60G
70%
/global/ds/xp17                   200G        128G         70G
65%
/global/ds/xp18                   200G        133G         65G
68%



sample of myFile:

    11     621 2008/03/21 12:44 xp4            256000 user/foo/INBOX
   806   41722 2008/03/21 13:26 xp47           256000 user/bar/INBOX
  2391  115428 2008/03/21 13:26 xp5            256000 user/moo/INBOX
  2452  122771 2008/03/21 12:38 xp6            256000 user/123/INBOX
   638   65484 2008/03/21 12:56 xp6            256000 user/345/INBOX
   139    4892 2008/03/21 12:44 xp7            256000 user/789/INBOX
   398   13403 2008/03/19 14:05 xp7            256000 user/1234/INBOX
   392   32448 2008/03/21 14:14 xp8            256000 user/5678/INBOX

   of which this:

   xxx@[EMAIL PROTECTED]
 awk {'print $5'}  myFile | sort |uniq -c | sort -n

shows:

   1407 xp45
   1496 xp40
   1503 xp51
   1524 xp49
   1537 xp50
   1539 xp42


where col 1 is the no. of accts. per "xp" partition.


my desired output will show col 1 (as above) on the appropriate row
(e.g. where partition matches, e.g. where col 2 above matches the end
of col 1 from my prog's out)

xxx@[EMAIL PROTECTED]
 ./foo

File System                          bytes        used   available
capacity	accts

------------------------------------------------------------------------------
/global/ds/xp45                    200G        139G         59G
71%	1407
/global/ds/xp40                    200G        131G         67G
66%	1496
/global/ds/xp51                   200G        129G         69G
66%	1503
/global/ds/xp49                   200G        133G         65G
68%	1524


Thanks again!
sg