Sample Header Ad - 728x90

Sort and Join with letters and numbers

0 votes
1 answer
937 views
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: File1: ARS-BFGL-BAC-1180 14 20574088 ARS-BFGL-BAC-11805 12 14897445 ARS-BFGL-BAC-11852 1 34309921 ARS-BFGL-BAC-11867 13 12616676 File2 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.
Asked by Augusto II (1 rep)
Apr 29, 2021, 01:56 PM
Last activity: Jan 5, 2023, 08:00 AM