Sorting awk array output?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sorting awk array output?
# 15  
Old 08-11-2011
Edit:
I was wrong again. I really need a rest. Sorry one more.

Last edited by yazu; 08-11-2011 at 01:13 PM.. Reason: Oops
# 16  
Old 08-11-2011
Quote:
Originally Posted by yazu
Edit:
I was wrong again. I really need a rest. Sorry one more.
No Problem at all...

Please rest now Smilie I will be back in the office on monday Smilie

Thanks anyway!
# 17  
Old 08-11-2011
Yes, this does not work:
Code:
cat INPUTFILE
a
d
c

awk '{ print | "sort" } END { print "END" }' INPUTFILE
END
a
c
d

But this does (at least for gawk):
Code:
awk '{ print | "sort" } END { close("sort"); print "END" }' INPUTFILE
a
c
d
END

You need to use exactly the same string for close, as for a pipe - "sort -k4" in your case.
# 18  
Old 08-15-2011
Quote:
Originally Posted by yazu
But this does (at least for gawk):
Code:
awk '{ print | "sort" } END { close("sort"); print "END" }' INPUTFILE
a
c
d
END

You need to use exactly the same string for close, as for a pipe - "sort -k4" in your case.
So how should I put this in my script? Does it also works with printf?
# 19  
Old 08-15-2011
Put this as the first statement after the second "END":
Code:
END { 
  close "sort -k4"
  ...
}

It doesn't matter what you use after - print or printf.
I've tested it with gawk, but this feature is not GNU extension so it should work.
# 20  
Old 08-15-2011
Quote:
Originally Posted by yazu
Put this as the first statement after the second "END":
Code:
END { 
  close "sort -k4"
  ...
}

It doesn't matter what you use after - print or printf.
I've tested it with gawk, but this feature is not GNU extension so it should work.
Hmm the sort function still doesn't work how I like to see it.. But maybe it is just impossible in the current code.. Will work on it. I think I have enough info.

A different question:
On the split command, it seems that spaces are not accounted for.
For some of the fields seperated by the / the outcome should be something like: "my department". But instead I get only "my". I have done some search on this and in all occasions I see that spaces are allowed and stored/printed.. So what am I doing wrong here ?

regards
# 21  
Old 08-15-2011
Quote:
But maybe it is just impossible in the current code.
Maybe. You really need refactoring.

On split. It should work as you want. But with spaces in the names of files you can not expect than your filename would be always in $9 in awk. For example with one space the first part before the space will be in $9 and the second - in $10.
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