sorting of varchar columns

UNIX for Advanced & Expert Users
1

Hi ,

I need to sort a file based on multiple columns All the columns are of varchar type
can any one give me the command to sort for varchar columns?

Thanks

2

can u give an example for the same?

3

the input file record are as below :

GB 10 GBEN 1 0 20080826 6548
GB 10 GBEN 2 0 20080826 6548
GB 10 GBEN 3 0 20080826 6548
GB 10 GBEN 10 0 20080826 6548
GB 10 GBEN 11 0 20080826 6548
GB 10 GBEN 18 0 20080826 6548
GB 10 GBEN 20 0 20080826 6548
GB 10 GBEN 22 0 20080826 6548
GB 10 GBEN 24 0 20080826 6548
GB 10 GBEN 29 0 20080826 6548
GB 10 GBEN 30 0 20080826 6548
GB 10 GBEN 34 0 20080826 6548
GB 10 GBEN 35 0 20080826 6548
GB 10 GBEN 37 0 20080826 6548

The out put should be
GB 10 GBEN 1 0 20080826 6548
GB 10 GBEN 10 0 20080826 6548
GB 10 GBEN 11 0 20080826 6548
GB 10 GBEN 18 0 20080826 6548
GB 10 GBEN 2 0 20080826 6548
GB 10 GBEN 20 0 20080826 6548
GB 10 GBEN 22 0 20080826 6548
GB 10 GBEN 24 0 20080826 6548
GB 10 GBEN 29 0 20080826 6548
GB 10 GBEN 3 0 20080826 6548
GB 10 GBEN 30 0 20080826 6548
GB 10 GBEN 34 0 20080826 6548
GB 10 GBEN 35 0 20080826 6548
GB 10 GBEN 37 0 20080826 6548

The requirement is firstly the sorting should be done on the last column and then 4th column hasto be sorted

4

Not sure if that was a typo what you showed as example but here you go:

root@isau02:/data/tmp/testfeld> cat infile
GB 10 GBEN 1 0 20080826 6548
GB 10 GBEN 2 0 20080826 6548
GB 10 GBEN 3 0 20080826 6548
GB 10 GBEN 10 0 20080826 6548
GB 10 GBEN 11 0 20080826 6548
GB 10 GBEN 18 0 20080826 6548
GB 10 GBEN 20 0 20080826 6548
GB 10 GBEN 22 0 20080826 6548
GB 10 GBEN 24 0 20080826 6548
GB 10 GBEN 29 0 20080826 6548
GB 10 GBEN 30 0 20080826 6548
GB 10 GBEN 34 0 20080826 6548
GB 10 GBEN 35 0 20080826 6548
GB 10 GBEN 37 0 20080826 6548
root@isau02:/data/tmp/testfeld> sort -k 7,7 -k 4,4 infile
GB 10 GBEN 1 0 20080826 6548
GB 10 GBEN 10 0 20080826 6548
GB 10 GBEN 11 0 20080826 6548
GB 10 GBEN 18 0 20080826 6548
GB 10 GBEN 2 0 20080826 6548
GB 10 GBEN 20 0 20080826 6548
GB 10 GBEN 22 0 20080826 6548
GB 10 GBEN 24 0 20080826 6548
GB 10 GBEN 29 0 20080826 6548
GB 10 GBEN 3 0 20080826 6548
GB 10 GBEN 30 0 20080826 6548
GB 10 GBEN 34 0 20080826 6548
GB 10 GBEN 35 0 20080826 6548
GB 10 GBEN 37 0 20080826 6548

If it was a type, add a -n or n in the form of "... -k 7,7n ..."