sort -t: -k2 fac > facS sort -t: -k1 rank > rankS join -t: -1 2 -2 1 facS rankS > join_result.all join -o 1.1 2.2 1.3 -t: -1 2 -2 1 facS rankS > join_result.some