sort

prasathlogu · #1 (**permalink**) 10-08-2007

Hi,
My file looks like as mentioned below:

2XYZ987654 Life Assurance
2BDS565656 Personal Pension
2ABC123456 Prudence Bond
2BDS565656 Distribution Bond
2BDS565656 Managed Bond
2ABC123456 FSAVC
1ABC123456 Mr John
1XYZ987654 Mrs Jane
1BDS565656 Miss Gail

Could you pls tell me, how to sort this file to get the output as mentioned below:
1ABC123456 Mr John
2ABC123456 FSAVC
2ABC123456 Prudence Bond
1BDS565656 Miss Gail
2BDS565656 Distribution Bond
2BDS565656 Managed Bond
2BDS565656 Personal Pension
1XYZ987654 Mrs Jane
2XYZ987654 Life Assurance

that means sorting based upon 2nd to 10th characters(assume it is one field) and then sorting based upon first character/number. This 2nd to 10 th characters is one filed and there is no delimiter between 1st and 2nd character.

Pls help me to sort out my file as per requirement ASAP. Thanks in advance.
Regards,
Prasath

zazzybob · #2 (**permalink**) 10-08-2007

Code:

$ sort -k1.2,1.10 -k1.1,1.1 -k2,2 ins.txt
1ABC123456 Mr John
2ABC123456 FSAVC
2ABC123456 Prudence Bond
1BDS565656 Miss Gail
2BDS565656 Distribution Bond
2BDS565656 Managed Bond
2BDS565656 Personal Pension
1XYZ987654 Mrs Jane
2XYZ987654 Life Assurance

Cheers,
ZB

Other UNIX.COM Threads You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
need help in sort	ali560045	Shell Programming and Scripting	2	12-04-2007 03:38 AM
sort help	unics	Shell Programming and Scripting	14	04-30-2007 04:28 AM
du -h \| sort ?	fongthai	Shell Programming and Scripting	6	11-02-2006 04:59 PM
How do i sort?	abhijeetkul	Shell Programming and Scripting	1	12-21-2005 11:49 PM
2nd sort key	whatisthis	UNIX for Dummies Questions & Answers	1	10-20-2004 07:46 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode