sort the org_no & member_type column ascending

new2ksh · #1 (**permalink**) 2 Weeks Ago

I have a FILE1.DAT with the following information

Code:

21111111110001343 000001004OLF-AA029100020091112
21111111110000060 000001004ODL-CH001000020091112
24444444440001416 000001045OLF-AA011800020091112
23333333330001695 000001039OLF-AA030600020091112
23333333330000111 000001039ODL-SP002000020091112
23333333330000060 000001039ODL-CH001000020091112
22222222220000780 000001013OLF-AA006500020091112

i want to sort the org_no column ie position 2:10 in ascending eg 111111111 then 222222222 then 333333333 etc.
also i want to sort the member_type column position 28:33 in asc eg:

for the line 4 above after sorting i should get like this

Code:

23333333330001695 000001039OLF-AA030600020091112
23333333330000060 000001039ODL-CH001000020091112
23333333330000111 000001039ODL-SP002000020091112

This i want in .KSH script, after i do the sort for the above 2 columns from the input FILE1.DAT i should get the out FILE2.DAT like below

Code:

21111111110001343 000001004OLF-AA029100020091112
22222222220000780 000001013OLF-AA006500020091112
23333333330001695 000001039OLF-AA030600020091112
23333333330000060 000001039ODL-CH001000020091112
23333333330000111 000001039ODL-SP002000020091112
24444444440001416 000001045OLF-AA011800020091112

thanks for the help

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Using sort command to get numeric ascending order	wali4813	Linux	3	3 Weeks Ago 05:03 PM
Question about sort specific column and print other column at the same time !	patrick87	Shell Programming and Scripting	3	10-07-2009 06:43 AM
Sort ascending and descending	don_0110	UNIX for Dummies Questions & Answers	1	11-27-2008 03:59 PM
Sort Numbers in ascending orders	Raynon	Shell Programming and Scripting	7	01-19-2007 02:03 AM
Sort / ascending order	gyik	UNIX for Dummies Questions & Answers	1	03-05-2001 10:08 AM

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


	Powered by