[SOLVED] merging columns from different files

leonardo2887 · 10-10-2010, 10:38 AM

Hello to everybody.

I have three files with the following structure:

file1
1 2 3 4
5 6 7 8

file2
9 10 11 12
13 14 15 16

file3
17 18 19 20
21 22 23 24

and I'd like to create a new file:

file4
1 2
5 6
9 10
13 14
17 18
21 22

I tried with awk, but I'm really new to this language... and I had no success...

It would be great if some of you could help me.

Thank you in advance,
Leonardo

GrapefruiTgirl · 10-10-2010, 10:48 AM

Perhaps this will work (one of probably several methods):

Code:

awk '{printf $1" "$2"\n"}' file1 file2 file3 > file4

ghostdog74 · 10-10-2010, 10:54 AM

Code:

awk '{print $1,$2}' file1  file2 file3

schneidz · 10-10-2010, 11:45 AM

man split cut paste

edit:
actually, the awks above are more appropriate.

leonardo2887 · 10-11-2010, 02:28 AM

Quote:

Originally Posted by GrapefruiTgirl

Perhaps this will work (one of probably several methods):

Code:

awk '{printf $1" "$2"\n"}' file1 file2 file3 > file4

Thank you very much. This one worked!