sort help 2

[ogniemi]

please tell me how to sort file by last 5 characters in 2nd column?

 

[feherke]

Hi

That is not something you can solve with a couple of options added to [tt]sort[/tt]. The solution would be to copy the substrings you want to sort by to the beginning of the lines, sort them, then remove the added substrings.

To choose the easier solution for this, the question is if the first and/or second field is fixed length.

Feherke.

http://rootshell.be/~feherke/

 

[ogniemi]

the second column has not fixed length.
the lenght of the second column is greather then 5.
the second column is combined of digits or digits with letters but the last 5 characters of the second column are always digits

for example, rows:
khsfs jsf23ls87234 lkjes
ljdfljg 872438744 lr9josslkfj
u9werowwr kh73y098234 j82u3roiwe
873yeuwh 8uwj87340 j8jerikfj98

I'd like to sort basing on red-marked digits...

 

[Annihilannic]

Implementing feherke's idea:

awk '{print substr($2,length($2)-4),$0}' inputfile | sort -n -k 1,1 | cut -d' ' -f 2- > outputfile

Annihilannic.