Help with sort alphabet on specific column

Shell Programming and Scripting
1

Input file:

POL     B7U6K8  Avian_reticuloendotheliosis_virus
POLB    B7Z1W5  Homo_sapiens
POLB    H9G5Y0  Anolis_carolinensis
POLD1   Q642R8  Xenopus_laevis
POLD2   H0YZC7  Taeniopygia_guttata
POLD3   F1P540  Gallus_gallus
POLDIP3 Q5F4B6  Gallus_gallus
POLE2   E1C2T8  Gallus_gallus
POLE3   F1P2L0  Gallus_gallus
POL     E6ZGJ1  Dicentrarchus_labrax
POL     E6ZGJ4  Dicentrarchus_labrax
POLE    E1C5P2  Gallus_gallus
POLE    G1RBL5  Nomascus_leucogenys
POL     F4Y5K7  Avian_reticuloendotheliosis_virus

Desired output

POL     B7U6K8  Avian_reticuloendotheliosis_virus
POL     F4Y5K7  Avian_reticuloendotheliosis_virus
POL     E6ZGJ1  Dicentrarchus_labrax
POL     E6ZGJ4  Dicentrarchus_labrax
POLB    H9G5Y0  Anolis_carolinensis
POLB    B7Z1W5  Homo_sapiens
POLD1   Q642R8  Xenopus_laevis
POLD2   H0YZC7  Taeniopygia_guttata
POLD3   F1P540  Gallus_gallus
POLDIP3 Q5F4B6  Gallus_gallus
POLE    E1C5P2  Gallus_gallus
POLE    G1RBL5  Nomascus_leucogenys
POLE2   E1C2T8  Gallus_gallus
POLE3   F1P2L0  Gallus_gallus

Can I know how to sort column 1 and column 3 content at the same time based on alphabet (sort A to Z) ?

Thanks for any advice.

2 
$ sort -k1 sort.txt
POL     B7U6K8  Avian_reticuloendotheliosis_virus
POL     E6ZGJ1  Dicentrarchus_labrax
POL     E6ZGJ4  Dicentrarchus_labrax
POL     F4Y5K7  Avian_reticuloendotheliosis_virus
POLB    B7Z1W5  Homo_sapiens
POLB    H9G5Y0  Anolis_carolinensis
POLD1   Q642R8  Xenopus_laevis
POLD2   H0YZC7  Taeniopygia_guttata
POLD3   F1P540  Gallus_gallus
POLDIP3 Q5F4B6  Gallus_gallus
POLE    E1C5P2  Gallus_gallus
POLE    G1RBL5  Nomascus_leucogenys
POLE2   E1C2T8  Gallus_gallus
POLE3   F1P2L0  Gallus_gallus

sort has various options like -k is for field and -t sep and -w -n -r ......read man sort for more details....

Thanks
Sha

1 Like
3 
sort -t" " -k1,2 input_file
1 Like
4 
sort -k1,1 -k3,3 input_file
1 Like