Some versions of awk provide a asort() and asorti() functions to sort data.
This example uses the sort utility to sort data and should work whether or not your version of awk has those functions. This would probably also be easier if it read in the three column input file rather than the unsorted matrix input, but I didn't want to take the time to add the entries you listed as ... to test the program. This example also automatically adjusts for varying input field widths:
When the above is saved in a file named sortmatrix and made executable with chmod +x sortmatrix run with a file named input that contains:
it produces the following output:
Note that if you change -v dbg=0 to -v dbg=1, this script will produce a debugging log file providing data that may be useful if you need to make changes to some part of the program's logic.
These 3 Users Gave Thanks to Don Cragun For This Post:
Hello, I have the following problem
I have two columns with numbers arranged as follows:
x1 y1
x2 y2
....
....
x250 y250
Now I need them arranged as follows:
"string a"
x1 y1
x1 y2
"string b"
"string a"
x1 y2
x2 y2 (3 Replies)
hi there
I'm very new in programing and i've started with awk.
I'm processing 200 data files and I need to do some precessing on them.
The files have 3 columns with N-lines
for each line a have on the first and second value is the same for all the files and only the third is variable. like... (2 Replies)
Hi,
I have a large data frame as shown below, where data is separated into years.
10 May 2011 Created: 10 May 11 15:05 GMT Scale: SIO-2005 and others
GC-MD, Cape Grim, Tasmania, Lat.: 40.68S, Lon.: 144.69E, Alt: 94m above sea level
You can use the following format in Fortran to read data... (4 Replies)
Hi everyone
I am very new at awk but think that that might be the best strategy for this. I have a matrix very similar to a correlation matrix and in practical terms I need to convert it into a list containing the values from the matrix (one value per line) with the first field of the line (row... (5 Replies)
Hi there,
If anyone can help me sorting out this small task would be great. Given a matrix like the following:
100 3 3 3 3 3 ...
200 5 5 5 5 5 ...
400 1 1 1 1 1 ...
500 8 8 8 8 8 ...
900 0 0 0 0... (5 Replies)
Hi,
I am required to arrange columns of a file i.e make the 15th column into the 1st column.
I am doing
awk 'begin {fs=ofs=","} {print $15,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}' ad.data>ad.csv
the problem is that column 15 gets to column 1 but it is not comma separated with the... (10 Replies)
How can I use awk to count the occurrence of field 2 and rearrange the output like below:
Input:
OA1 FM AA
OA0 FM CC
ON0 FM CC
FN1 FN BB
OY1 FN BB
OY2 FN CC
OY3 FN CC
YT0 FM AA
KW1 FN CC
KW3 FM BB
YT4 FM AA
FN2 FT BB
OA3 FT AA
ON7 FM BB (14 Replies)
This is my first post, I apologize if I have broken rules.
Some assistance with the following will be very helpful.
I have a couple of files, both should ultimately have common columns only, arranged in the same order.
This file needs to be transposed, to bring the rows to columns
... (2 Replies)