Sorting awk array output? Post: 302546483

Sponsored Content

Top Forums Shell Programming and Scripting Sorting awk array output? Post 302546483 by Cowardly on Thursday 11th of August 2011 09:58:30 AM

08-11-2011

Registered User

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

Cowardly

View Public Profile for Cowardly

Find all posts by Cowardly

10 More Discussions You Might Find Interesting

1. 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...

2. 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}

3. 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...

4. 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...

5. 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...

6. 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...

7. 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...

8. 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

9. 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 )...

10. 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:

LEARN ABOUT OPENSOLARIS

vdltodmx

vdltodmx(1)						      General Commands Manual						       vdltodmx(1)

NAME

       vdltodmx - dmx configuration file parser and printer

SYNOPSIS

       vdltodmx infile outfile

DESCRIPTION

       vdltodmx  reads	the  input file, which should be in VDL configuration file format.  After a successful parse, a file in Xdmx configuration
       file format is written to the output file.

       The VDL file format is used with xmovie, which is available from http://www.llnl.gov/icc/lc/img/xmovie/xmovie.html

EXAMPLE

       Given the following VDL-format file:
	      0
	      2
	      #
	      #
	      2560 2048 Left two-thirds [restrict=*:2]
	      2
	      :2.1 1280 2048   0    0 0 0
	      :2.2 1280 2048   1280 0 0 0
	      4
	      1280 1024 0      0
	      1280 1024 0      1024
	      1280 1024 1280   0
	      1280 1024 1280   1024
	      #
	      2560 2048 Right two-thirds [restrict=*:2]
	      2
	      :2.2 1280 2048   0   0 0 0
	      :2.3 1280 2048   1280 0 0 0
	      4
	      1280 1024 1280	0
	      1280 1024 1280	1024
	      1280 1024 2560 0
	      1280 1024 2560 1024
       the following DMX-format file will be produced:
	      #
	      #
	      virtual "Left two-thirds" 2560x2048 {
		  display :2.1 1280x2048;
		  display :2.2 1280x2048 @1280x0;
	      }
	      #
	      virtual "Right two-thirds" 2560x2048 {
		  display :2.2 1280x2048;
		  display :2.3 1280x2048 @1280x0;
	      }

BUGS

       If the VDL file is not in the expected format, the program will probably dump core.

SEE ALSO

       Xdmx(1), xdmxconfig(1), vdl(3), xmovie(1)

X Version 11							xorg-server 1.12.4						       vdltodmx(1)