NICE code! Thank you very much for your great work.
I faced another problem and don't know how to fix it.
I have some columns like this:
HTML Code:
SA1
SA2
SA11
SA3
SA5
SA27
SA10
SA15
SA25
It showed the following result after sorted:
HTML Code:
SA1
SA10
SA11
SA15
SA2
SA25
SA27
SA3
SA5
What should I do if I want the sorted result like this:
HTML Code:
SA1
SA2
SA3
SA5
SA10
SA11
SA15
SA25
SA27
Many thanks!
If all of your header names are exactly two alphabetic characters followed by one or more numeric characters, you could change the sort command for the column headings from:
to:
and use csc (column sort command) instead of sc when sorting the column headers. But if only some of your names fit this pattern, the easiest thing to do is to rename your headers so they have leading zeros to make an alphabetic sort work, (i.e., SA01, SA02, SA03, SA05, SA10, SA11, SA15, SA25, and SA27). This could be coded into the awk program, but I don't have the time to devote to adding the leading zeros before sorting them, stripping off the leading zeros after sorting them, and figuring out what to do if one of you input column names already as a 0 followed by other numeric characters.
Do you also have a problem with sort order for the first field in the rows in your matrix?
This User 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)