Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Sorting awk array output?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sorting awk array output?
# 1  
Old 08-11-2011
Sorting awk array output?
Hi all,

I have a script which produces a nice table but I want to sort it on column 3.

This is the output line in the script:
Code:
# Output
        { FS = ":";
        format = "%11s %6s %-16s\n";
        prinft "\n"
        printf ( format, "Size","Count","Who" ) }
        for (i in u_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (u_size[i]>=x) {
        usersize = sprintf ( "%.2f %s", u_size[i]/x,hum[x] )
        printf ( format,usersize, u_count[i], i);break } } }
                          }
                }
        for (i in all_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (all_size[i]>=x) {
        allsize = sprintf ( "%.2f %s", all_size[i]/x,hum[x] )
        printf ( format,allsize, all_count[i], "Total");break } } }
                        }
        }
}'

And this is a possible output

Code:
 Size  Count Who             
    1.96 Gb   2007 Uitvoerend      
   63.54 Mb    167 Juridische      
  354.68 Mb    465 Beleidsvoorbereiding
   36.69 Gb  20439 Marketing       
  966.32 Kb      5 DWHN            
..
...

...
 175.62 Gb 133569 Total


Is it possible to sort this on column 3 ?

Regards,

Ronald
# 2  
Old 08-11-2011
Try piping this output to:
Code:
| sort -rk3

# 3  
Old 08-11-2011
Only -k4 and with -r the header would be the footer. :-)
Try to add | "sort -k4" to the every print/printf statements in awk except those printing the header/footer.
# 4  
Old 08-11-2011
Quote:
Originally Posted by yazu
Only -k4 and with -r the header would be the footer. :-)
Try to add | "sort -k4" to the every print/printf statements in awk except those printing the header/footer.
Quote:
Originally Posted by bartus11
Try piping this output to:
Code:
| sort -rk3


Where should I put this.... ??
# 5  
Old 08-11-2011
I'm not sure how are you calling the AWK code, but try this:
Code:
# Output
        { FS = ":";
        format = "%11s %6s %-16s\n";
        prinft "\n"
        printf ( format, "Size","Count","Who" ) }
        for (i in u_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (u_size[i]>=x) {
        usersize = sprintf ( "%.2f %s", u_size[i]/x,hum[x] )
        printf ( format,usersize, u_count[i], i);break } } }
                          }
                }
        for (i in all_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (all_size[i]>=x) {
        allsize = sprintf ( "%.2f %s", all_size[i]/x,hum[x] )
        printf ( format,allsize, all_count[i], "Total");break } } }
                        }
        }
}' | sort -rk3

# 6  
Old 08-11-2011
Quote:
Originally Posted by bartus11
I'm not sure how are you calling the AWK code, but try this:
Code:
# Output
        { FS = ":";
        format = "%11s %6s %-16s\n";
        prinft "\n"
        printf ( format, "Size","Count","Who" ) }
        for (i in u_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (u_size[i]>=x) {
        usersize = sprintf ( "%.2f %s", u_size[i]/x,hum[x] )
        printf ( format,usersize, u_count[i], i);break } } }
                          }
                }
        for (i in all_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (all_size[i]>=x) {
        allsize = sprintf ( "%.2f %s", all_size[i]/x,hum[x] )
        printf ( format,allsize, all_count[i], "Total");break } } }
                        }
        }
}' | sort -rk3

Almost...
I will try to put it on different levels but you gave me a starter..

Code:
  Size  Count Who             
Total Size = 6.16 Gb
  63.02 Mb     56 Automatisering  
   3.64 Mb      1 Karaoke         
  45.79 Mb      2 Muziekfeesten   
   4.95 Gb    175 Opgelicht       
  72.67 Mb     12 Radar           
 493.33 Mb     24 RegelRecht      
   6.16 Gb    308 Total           
 410.69 Mb     10 Vermist         
 146.40 Mb     28 Zappsport

Ok: this is tricky..
If I put the sort command else where I receive an error :
awk: syntax error at source line 41
context is
} >>> | <<< sort -k4
awk: illegal statement at source line 42

My guess is I have to seperate my header / footer from the data.
(will have to figure that out :P)

This is the complete array output (FYI) :

Code:
{
        for (I=9 ; I<=NF ; I++) { x++ } { size=size+$5 }
}
END { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (size>=x) { { printf "Total Size = ",NR }
        printf "%.2f %s\n\n",size/x,hum[x];break }
        }
# Output
        { FS = ":";
        format = "%11s %6s %-16s\n";
        prinft "\n"
        printf ( format, "Size","Count","Who" ) }
        for (i in u_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (u_size[i]>=x) {
        usersize = sprintf ( "%.2f %s", u_size[i]/x,hum[x] )
        printf ( format,usersize, u_count[i], i);break } } } | sort -k4
                          }
                }           
        for (i in all_count) {
                if (i != "") {
                { hum[1024**4]="Tb"; hum[1024**3]="Gb"; hum[1024**2]="Mb"; hum[1024]="Kb";
        for (x=1024**4; x>=1024; x/=1024) { if (all_size[i]>=x) {
        allsize = sprintf ( "%.2f %s", all_size[i]/x,hum[x] )
        printf ( format,allsize, all_count[i], "Total");break } } }
                        }
        }
}'

Last edited by Cowardly; 08-11-2011 at 12:18 PM..
# 7  
Old 08-11-2011
Add double quotes:
Code:
printf ( format,usersize, u_count[i], i);break } } } | "sort -k4"

Try this example with and without quotes:
Code:
echo 'a
d
b' | awk '{print | "sort"}'
a
b
d
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh : need to store the output of a awk command to a array

I have awk command : awk -F ' ' '{ print $NF }' log filename And it gives the output as below: 06:00:00 parameters: SDS (2) no no no no doc=4000000000). information: (6 Replies)
Discussion started by: ramprabhum
6 Replies

2. Shell Programming and Scripting

Sorting output of AWK array

I need help to sort the output of an awk array Example datadata="1 blue 2 green 3 blue 4 yellow 5 blue 6 red 7 yellow 8 red 9 yellow 10 yellow 11 green 12 orange 13 black" My awk line to get output in one lineecho "$data" | awk ' {arr++; next} END { for (i in arr) { if(arr>1 )... (2 Replies)
Discussion started by: Jotne
2 Replies

3. Shell Programming and Scripting

Need to have output of AWK array in one line

I have this code echo $logfile | awk ' {arr++; next} END { for (i in arr) {print i} }' that gives me this output result1 result2 result3 I try to figure out how to get it like this result1 result2 result3 (4 Replies)
Discussion started by: Jotne
4 Replies

4. Shell Programming and Scripting

awk assign output of array to specific field-number

With this script i want to print the output to a specific field-number . Can anybody help? awk 'NR=FNR{split(FILENAME,fn,"_");nr=$2;f = $1} END{for (i=1;i<=f;i++) print i,$fn=nr}' input_5.csv input_6.csvinput_5.csv 4 135 5 185 6 85 11 30input_6.csv 1 90 3 58 4 135 7 60 8 55 10... (1 Reply)
Discussion started by: sdf
1 Replies

5. Shell Programming and Scripting

awk output error while loop through array

Have built this script, the output is what I needed, but NR 6 is omitted. Why? Is it an error? I am using Gawk. '{nr=$2;f = $1} END{for (i=1;i<=f;i++) if (nr != i) print i, nr }' input1.csv >output1.csvinput1.csv 1 9 3 5 4 1 7 6 8 5 10 6 output1.csv > with the missing line number 6. 6 is... (5 Replies)
Discussion started by: sdf
5 Replies

6. Shell Programming and Scripting

awk - Pre-populating an array from system command output

So, here's a scenario that requires the same logic as what I'm working on: Suppose that you have a directory containing files named after users. For awk's purposes, the filename is a single field-- something parse-friendly, like john_smith. Now, let's say that I'd like to populate an array in... (2 Replies)
Discussion started by: treesloth
2 Replies

7. Shell Programming and Scripting

perl array sorting

Hi All, I have an array in perl as @match = (201001,201002,201001,201002); I am trying to sort this array as @match = sort(@match); print "@match"; I dont see the output sorted any answers I also tried another way, but still the results are not sorted foreach my $match (sort { $a... (2 Replies)
Discussion started by: bsdeepu
2 Replies

8. Shell Programming and Scripting

Sorting Awk generalized array

Generalized arrays take any type of variable(s) as subscripts, but the subscript(s) are treated as one long string expression. The use of for(a in x) on a generalized array will return all of the valid subscripts in some order, not necessarily the one you wished. How can I make it so that i... (2 Replies)
Discussion started by: gio001
2 Replies

9. Shell Programming and Scripting

bash:awk output into an array

Hi, I have a file 1:apple orange:one 2:banana:two 3:cherry:3 When I do awk -F: ' { print $2 } ' file apple orange banana cherry Now, when i redirect awk output to the file it has issue with strings #!/bin/bash FILEA=file A=(`awk -F: ' { print $2 } ' $FILEA `) echo ${A} (2 Replies)
Discussion started by: phamp008
2 Replies

10. Shell Programming and Scripting

move output of awk to array

Hi experts, I have a the following awk command, awk '{print $1}' /users/jon/list4.txt. The output is 123 787 888 ... ... I want to move the output to array using shell programming. My shell is tcsh. Is it possible to move to array using shell porg? I know its possible in... (14 Replies)
Discussion started by: amitrajvarma
14 Replies
Login or Register to Ask a Question