Sort and vectors on awk

Thread Tools Search this Thread
# 1  
Sort and vectors on awk


i have a script and it makes a txt like this :

Caps 12
cans 9
cols 10

my print line is something like this

for(i in a)
                print i, a[i];

i have to order the txt from higher to low like:

Caps 12
cols 10
cans 9

and i have two questions:

- is there a way to sort before printing?

- how can you sort a[i] because i refers to a value not a position (i its not < or > because it will be Caps, Cols or Cans), and i cannot change it like in java or c when you do something like this:

for (i = 0; i < X.length; i++)
for (j = i; j < X.length-1; j++)
if (X[j] > X[j+1])
aux = X[j];
X[j] = X[j+1];
X[j+1] = aux;

but in this case i is a position or a value?, im so confused about this way to use vectors, if someone can explain a little or give me documentation about vectors in awk /unix i will apreciate it.

thanks for all
# 2  
It helps if you tell us what Linux /UNIX you are using. Some awk implementations have asort() which is array sort. Other do not - so the correct answer for you depends on the system you are on.
# 3  
The mawk man page has an example of a string array sort.
# 4  
im on aix
# 5  
Here are three ways to sort your array that should work even if you don't have gawk:
awk '{  # Read the input file in to array a.
        a[$1] = $2
END {   # Use the sort utility to print array a in sorted order.
        print "print | sort:"
        cmd = "sort -k2nr" # Sort 2nd field as a numeric value in reverse order
        for(i in a) print i, a[i] | cmd

        # Copy a into b and c using an insertion sort to keep b and c sorted as
        # entries are added.
        for(k in a) {
                b[++nc] = k
                c[nc] = a[k]
                for(i = nc; i > 1; i--)
                        if(c[i] > c[i - 1]) {
                                tmp = b[i - 1]
                                b[i - 1] = b[i]
                                b[i] = tmp
                                tmp = c[i - 1]
                                c[i - 1] = c[i]
                                c[i] = tmp
                        } else  break;
        print "print sorted b and c"
        for(i = 1; i <= nc; i++) print b[i], c[i]

        # Loop through original array printing and deleting the largest value.
        # This loop destroys the array as it prints it.
        print "print largest value in loop:"
        for(i = 1; i <= NR; i++) {
                max = 0
                for(j in a) if(a[j] > max) {
                        max = a[j]
                        mj = j
                print mj, a[mj]
                delete a[mj]
}' file.txt

On Solaris/SunOS systems, use /usr/xpg4/bin/awk or nawk instead of awk. On AIX or any other UNIX or Linux system, this should be fine as shown.

With your sample input, this awk script produces:
print | sort:
Caps 12
cols 10
cans 9
print sorted b and c
Caps 12
cols 10
cans 9
print largest value in loop:
Caps 12
cols 10
cans 9

# 6  
nawk - how to print variable value to a file?


I have a shell script which uses an awk program inside. There is a variable $count inside an "if" loop which counts the no of iterations.

Now, how to print that $count value to file (or) how to export that value to a variable outside awk program. i.e, awk to shell ?

Please help.
# 7  
Originally Posted by xshock

I have a shell script which uses an awk program inside. There is a variable $count inside an "if" loop which counts the no of iterations.

Now, how to print that $count value to file (or) how to export that value to a variable outside awk program. i.e, awk to shell ?

Please help.
I don't see what this has to do with sorting in awk (or nawk).

Please start a new thread to discuss this new issue and provide example code that is not working for you. ($count in a shell script is very different from $count in awk and nawk. You print a value explicitly in awk and nawk with a call to print or printf. There are lots of ways to print data implicitly depending on what you're doing.)

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #773
Difficulty: Medium
A finite-state machine (FSM) is a specialized computer developed by AT&T.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort String using awk

Hi, I need help to sort string using awk. I don't want to use sed or perl as I want to add this functionality in my existing awk script Basically I have a variable in AWK which is string with comma separated value. I want to sort that string before using that variable in further processing for... (10 Replies)
Discussion started by:
10 Replies

2. Shell Programming and Scripting

Need help on horizontal sort with AWK

dear friends.. i have data : 20130603;ABCD;ABCD1;14030;51271;0.000;0.000;21.000 20130603;ABCD;ABCD2;14030;51272;4853.000;53591.000;40539.000 20130603;ABCD;ABCD3;14030;51273;38024.000;385068.000;396424.000 20130603;ABCD;EFGH1;14030;51334;285879.000;563964.000;141780.000... (4 Replies)
Discussion started by: buncit8
4 Replies

3. Shell Programming and Scripting

how to sort inside awk

Hi guys I have a problem trying to sort output produced with the help of 'Awk'. After "grepping" the pattern out of the file and sorting it, sort command acts a little strange: $ grep -w -n -i "p*cmo" /bb/data/rmt4db.lrl | sort -r 32:P1096CMO 63836 344 passthru 31:P1084CMO 121335 329 passthru... (3 Replies)
Discussion started by: aoussenko
3 Replies

4. Shell Programming and Scripting

awk sort

input file abc1 abc23 abc12 abc15 output abc1 abc12 abc15 abc23 (9 Replies)
Discussion started by: yanglei_fage
9 Replies

5. Shell Programming and Scripting

Awk sort and unique

Input file --------- 12:name1:|host1|host1|host2|host1 13:name2:|host1|host1|host2|host3 14:name3: ...... Required output --------------- 12:name1:host1(2)|host1(1) 13:name2:host1(2)|host2(1)|host3(1) 14:name3: where (x) - Count how many times field appears in last column ... (3 Replies)
Discussion started by: greycells
3 Replies

6. Shell Programming and Scripting

Sort with Awk, sed ....

I want to print out the lines that have the max value in column 3. and count the occurrence of column 1; if there are more than one occurrences, line with highest column 2 value will be printed. I have this data: input: AV 234 25 AV 256 76 AS 421 34 AV 124 76 BD 136 71 BD 241 76 AW... (10 Replies)
Discussion started by: aydj
10 Replies

7. Shell Programming and Scripting

Using Awk to efficiently substitute values using 3 vectors

I'm trying to efficiently combine the fields of two vectors (vectors b and c) into a new vector (vector d) as defined by instructions from a 3rd vector (vector a). So vector a has either a 1 or 2 in each field specifying which vector (b or c respectively) should go into that field. Vector a is... (4 Replies)
Discussion started by: LaTortuga
4 Replies

8. Shell Programming and Scripting

Sort in AWK

Hi, I usually use Access to sort data however for some reason its not working. Our systems guys and myself cannot figure it out so ive tried to use AWK to do the sorting. The file is made up of single lines in the format ... (4 Replies)
Discussion started by: eknryan
4 Replies

9. Homework & Coursework Questions

awk sort help

1. The problem statement, all variables and given/known data: I dont know what I do wrong, I am trying to create shell programming database: I have this command first: && > $fname ... echo $Name:$Surname:$Agency:$Tel:$Ref: >> $fname then I have echo " Name Surname Agency Tel... (2 Replies)
Discussion started by: jeht
2 Replies

Featured Tech Videos