From: Agustin Lobo <alobo@ija.csic.es>
Subject: simple (g)awk code
Is there anybody "fluent" in awk (or gawk)
who could help me with a simple script?I just need to read the output of 3
files produced by r.stat, so like:1 val1a val2a val3a
2 val1a val2a val3a
3 val1a val2a val3a
...("a" indicates that the values are the ones
from the first file)and then make one single file in the form:
1 val1a val2a val1b val2b val1c val2c val3
2 val1a val2a val1b val2b val1c val2c val3
3 val1a vala2 val1b valb2 val1c val2c val3
...
Sure. With the "paste" command and "(g)awk".
paste puts the columns of each file together on one line:
1 val1a val2a val3a 1 val1b val2b val3b 1 val1c val2c val3c
2 val1a val2a val3a 2 val1b val2b val3b 2 val1c val2c val3c
...
column guide
1 2 3 4 5 6 7 8 9 10 11 12
Use gawk to get the columns you want:
paste file_a file_b file_c | awk '{print $1,$2,$3,$6,$7,$10,$11,$4}' > file_abc
I don't know which val3 you wanted, but the procedure is pretty straightforward.
If the column separators are the same in the files (i.e. tabs) as between the
files (paste defaults to a tab), the utility "cut" can also be used.
paste file_a file_b file_c | cut -f 1,2,3,6,7,10,11,4 > file_abc
Ben Horner-Johnson
ben@earth.nwu.edu