Hi all
I am new to programming. I have two very big files
File 1: (>80,000 lines)
CCDS635.1_0 123 G S 255 33 1.00 63 60 G 255 C
CCDS635.1_0 175 C S 255 51 0.94 63 62 C 243 G
CCDS635.1_8 259 G R 90 254 1.00 63 62 G 255 A
CCDS635.1_14 328 A T 39 4 0.00 63 36 N 158 N
CCDS635.1_16 80 G K 139 22 1.00 63 62 G 255 T
File 2:
CCDS635.1_0 1 67162857
CCDS635.1_1 1 67143396
CCDS635.1_2 1 67131424
CCDS635.1_3 1 67129349
CCDS635.1_4 1 67112976
I want to insert all three columns of File 2 to File one at the
respective positions according to column 1 of File 1.
e.g.
File 3 should be
CCDS635.1_0 1 67162857 123 G S 255 33 1.00 63 60 G 255 C
CCDS635.1_0 1 67162857 175 C S 255 51 0.94 63 62 C 243 G
Can anyone help me with this?
Manav
I am new to programming. I have two very big files
File 1: (>80,000 lines)
CCDS635.1_0 123 G S 255 33 1.00 63 60 G 255 C
CCDS635.1_0 175 C S 255 51 0.94 63 62 C 243 G
CCDS635.1_8 259 G R 90 254 1.00 63 62 G 255 A
CCDS635.1_14 328 A T 39 4 0.00 63 36 N 158 N
CCDS635.1_16 80 G K 139 22 1.00 63 62 G 255 T
File 2:
CCDS635.1_0 1 67162857
CCDS635.1_1 1 67143396
CCDS635.1_2 1 67131424
CCDS635.1_3 1 67129349
CCDS635.1_4 1 67112976
I want to insert all three columns of File 2 to File one at the
respective positions according to column 1 of File 1.
e.g.
File 3 should be
CCDS635.1_0 1 67162857 123 G S 255 33 1.00 63 60 G 255 C
CCDS635.1_0 1 67162857 175 C S 255 51 0.94 63 62 C 243 G
Can anyone help me with this?
Manav
Comment