UNIX for Dummies Questions & Answers

Hi,

I've got two files to match. File one:

and file 2

I need to match them by the first column and add the four columns of file 2 to the file 1 so that those added columns go as columns 4-7

the merged file should look like this:

I've tried matching them with awk, but the merged columns always end up being in the end of the file, not sure how to insert them to the right place.

Many thanks for your time and help in advance!

Try:

Code:

join -j1 -o1.1,1.2,1.3,2.2,2.3,2.4,2.5,1.4,1.5 file1 file2

Hi,

Thank you for your reply!

I am sorry, the example files are small, but in reality file one has 45700 columns :-(

Try:

Code:

awk 'NR==FNR{x=$1;$1="";a[x]=$0;next}{$3=$3""a[$1]}1' file2 file1

yap! that works!
Thank you so very much!!!!

Hello,

Following may help too.

Code:

awk 'NR==FNR{a[$1]=$2 OFS $3 OFS $4 OFS $5;next} ($1 in a){print $1 OFS $2 OFS $3 OFS a[$1] OFS $4 OFS $5}' check_file_order_check12114 check_file_order_check12113

Output will be as follows.

Code:

a1 b c 1 2 3 4 d e
a2 b c 5 6 7 8 d e
a3 b c 9 10 11 12 d e
a4 b c 1 2 3 4 d e

Where check_file_order_check12114 is file2 and check_file_order_check12113 is file1.


Thanks,
R. Singh