copy/paste columns

Serg · #1 (**permalink**) 06-09-04, 10:36

Hi.

I have two files with hundreds of columns on each of them.
Let's say :

<file 1> <file 2>

1 a q1 ... 12 4 65 ... e
2 b e2 ... a 0 ty ... 33
3 c s ... 3d 7 5t ... 21q
... .. .. ... zz ... .. .. d4
N B 43 ... d4 t5 44 .. b3

How can I build a third file with these columns intercalated ?

<file 3>

1 4 a 65 q1 ...e 12
2 0 b ty e2 ...33 a
3 7 c 5t s ...21q 3d
.. .. .. .. . .. ...d4 zz
N t5 B 44 43 ... b3 d4

Thanks,

Serg

vgersh99 · #2 (**permalink**) 06-09-04, 10:49

man paste

vlad

Serg · #3 (**permalink**) 06-10-04, 11:08

Vlad,

Thanks for the suggestion but "paste" does not work in this problem.
I need to intercalate column by column from both files.
I can not simply attach the two files.

Thanks,

Serg

Damian Ibbotson · #4 (**permalink**) 06-10-04, 12:45

Quote:

Thanks for the suggestion but "paste" does not work in this problem.

Sure it does...

Paste the file together, then order the fields.

Code:

paste file1 file2 | awk '{print $1,$3,$2,$4}'

Damian

Serg · #5 (**permalink**) 06-10-04, 15:24

Thanks, Damian.

It worked fine !!!

Serg · #6 (**permalink**) 06-10-04, 15:25

Damian,

I forgot to mention...the real problem
deals with 400 columns on each file (therefore
the output will have 800 columns).

Serg

Damian Ibbotson · #7 (**permalink**) 06-11-04, 06:55

Code:

paste f1 f2 | awk '{for (i=1; i<=NF/2; i++){printf "%s %s ",$i,$NF/2+1};printf "\n"}'

Serg · #8 (**permalink**) 06-14-04, 08:26

Thanks a lot, Damian !!!!!!!!!!!!!!!!!!

Damian Ibbotson · #9 (**permalink**) 06-14-04, 08:29

Oops! Looking at that again, I think I made a mistake with the printf output...

Code:

awk '{for (i=1; i<=NF/2; i++){printf "%s %s ",$i,$NF/2+i};printf "\n"}'

Internet Services

Web Development

Digital Marketing

Consumer Tech