I have two files (file1 and file2) and I would like to mount a third (file3) containing a column that the two do not have. I usually do the sort and then together with the join. But it is not working, because it has values with letters and numbers from the example below:
ARS-BFGL-BAC-1180 14 20574088 ARS-BFGL-BAC-11805 12 14897445 ARS-BFGL-BAC-11852 1 34309921 ARS-BFGL-BAC-11867 13 12616676
AC16359 ARS-BFGL-BAC-11798 B B AC16359 ARS-BFGL-BAC-11805 B B AC16359 ARS-BFGL-BAC-1180 B B AC16359 ARS-BFGL-BAC-11852 A A AC16359 ARS-BFGL-BAC-11867 B B
I notice that I use the same sort command for both and note that the final SNP_Name 11805 is above 1180 and the other is not.