UNIX for Dummies Questions & Answers

So I have two text files. The first one looks like this:

refsnp_id chr_name chrom_start
1 rs1000000 12 126890980
2 rs10000010 4 21618674
3 rs10000012 4 1357325
4 rs10000013 4 37225069
5 rs1000002 3 183635768

And the second one looks like this:

AUC rs1000000 0.03 0.1240
AUC rs10000010 0.03 0.1462
AUC rs10000012 0.00 0.8628
AUC rs10000013 0.00 0.5459
AUC rs1000002 0.00 0.6439
AUC rs10000023 0.03 0.1337
AUC rs10000027 0.00 0.7142
AUC rs10000030 0.00 0.7634
AUC rs1000003 0.02 0.2226


The second columns of the two text files match but not completely. There are some missing lines in the first text file. I want to merge the two text files by their second columns and add the third and fourth column of the first file to the second file when the second columns of the two files are matching. How do I go about doing that? Thanks!

Post desired output for this data.

AUC rs1000000 0.03 0.1240 12 126890980
AUC rs10000010 0.03 0.1462 4 21618674
AUC rs10000012 0.00 0.8628 4 1357325
AUC rs10000013 0.00 0.5459 4 37225069
AUC rs1000002 0.00 0.6439 3 183635768

Thanks!

Try:

Code:

join -12 -22 -o 2.1,2.2,2.3,1.3,1.4 <(sort -k2,2 file1) <(sort -k2,2 file2)

You can even use "join -j 2" instead of "join -1 2 -2 2"