Awk command needed to sort and group 1

[codesearcher]

Hi
I need a unix script to sort & group the below record based on the last value of the line
eg: In below file, i should sort & group all 1's and next 2's

P0001|Jim|1001|1
P0002||1002|abcdne|2
P0003|Jack|1001|test|csx|1
P0003|Till|1003|dlf|2
P0010|Tusk|1011|xyz|unites|shift|1

I am struck after using this statement awk -F'|' '{ printf $0}'
Any help is welcome

 

[Annihilannic]

The difficulty is that the sort field isn't always in the same field number, so you can't just use the sort command.

Alternatively you can use awk to create a new field on the beginning of the line, sort it by the first field, and then use sed to strip it off again:

awk -F'|' '{print $NF FS $0}' inputfile | sort -t'|' -n -k 1,1 | sed 's/[0-9]*\|//'

Annihilannic.

 

[codesearcher]

cool it works... thank u