Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Sorting output of AWK array

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sorting output of AWK array
# 1  
Old 10-19-2012
Sorting output of AWK array
I need help to sort the output of an awk array

Example data
Code:
data="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 line
Code:
echo "$data" | awk  ' {arr[$2]++; next} END { for (i in arr) { if(arr[i]>1 ) printf "%s(%s) ",i,arr[i]};print "" }'

gives this output:
Code:
red(2) yellow(4) green(2) blue(3)

I need to count all hits, then print all with 2 or more hits sorted in one line like this (high to low):
Code:
yellow(4) blue(3) red(2) green(2)



I did look at the xargs and sort command, but this sorts on name.
Code:
echo "$data" | awk  ' {arr[$2]++; next} END { for (i in arr) { if(arr[i]>1 ) printf "%s(%s) ",i,arr[i]};print "" }' | xargs -n 1| sort | xargs

This gives Smilie
Code:
blue(3) green(2) red(2) yellow(4)

Would be nice if all can be done in awk
# 2  
Old 10-19-2012
Hi

Code:
echo "$data" | awk  ' {arr[$2]++; next} END { for (i in arr) { if(arr[i]>1 ) printf "%s %s \n",i,arr[i]};}' | sort -k2nr,2 | awk '$2="("$2")"' OFS="" | xargs
yellow(4) blue(3) green(2) red(2)


Guru.
# 3  
Old 10-19-2012
Quote:
Originally Posted by Jotne
[...]Would be nice if all can be done in awk
It can, with GNU awk >= 4:
Code:
% printf "%s\n" "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" |
  awk 'END {
  PROCINFO["sorted_in"] = "@val_num_desc"
  for (d in data)
    if (data[d] > 1)
      printf "%s(%d) ", d, data[d]
  print x
  }
{
  data[$2] = ++count[$2]
  }'
yellow(4) blue(3) red(2) green(2)

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

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

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

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

5. Shell Programming and Scripting

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: # Output { FS = ":"; format = "%11s %6s %-16s\n"; prinft "\n" printf ( format, "Size","Count","Who" ) } for (i in... (21 Replies)
Discussion started by: Cowardly
21 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