![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ksh - test if string contains alphanumeric... | tugger | Shell Programming and Scripting | 3 | 10-16-2007 04:23 AM |
| alphanumeric comparision | rakeshou | Shell Programming and Scripting | 3 | 09-27-2007 11:32 AM |
| AlphaNumeric String Operations | lakshmikanth | UNIX for Dummies Questions & Answers | 3 | 01-05-2007 06:55 AM |
| sort command - alphanumeric | gefa | Shell Programming and Scripting | 4 | 08-30-2006 10:36 AM |
| matching alphanumeric string | sskb | Shell Programming and Scripting | 4 | 12-12-2001 10:48 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
alphanumeric Sorting
Hi ,
I have a requirement where one column have to be sorted (delimiter is pipe) for eg: My input filed is as below 1|FIAT|0010103|23011|01/01/2000|31/12/9999|1.15 2|232|613|1 2|234|743|1 2|234|793|1 2|234|893|1 1|FIAT|0010103|23012|01/01/2000|31/12/9999|1.15 2|230|006|0 2|230|106|0 2|230|116|0 2|230|716|0 1|FIAT|0010103|113013|01/01/1996|31/12/9999|1.15 2|231|966|0 2|232|747|0 1|FIAT|0010103|123014|01/01/2000|31/12/9999|1.15 2|232|717|0 2|232|718|0 2|232|728|0 2|232|818|0 I need to do alphanumeric (dictionary) sort for all the columns marked in red for only thoes record which start with '1'. Record '1' should followed by all thoes which start with '2' and my desired out put is 1|FIAT|0010103|113013|01/01/1996|31/12/9999|1.15 2|231|966|0 2|232|747|0 1|FIAT|0010103|123014|01/01/2000|31/12/9999|1.15 2|232|717|0 2|232|718|0 2|232|728|0 2|232|818|0 2|232|827|0 2|232|828|0 1|FIAT|0010103|23011|01/01/2000|31/12/9999|1.15 2|232|613|1 2|234|743|1 2|234|793|1 2|234|893|1 1|FIAT|0010103|23012|01/01/2000|31/12/9999|1.15 2|230|006|0 2|230|106|0 2|230|116|0 2|230|716|0 Is ther any command to sort such kind of input data? |
|
||||
|
sorry my desired output is as below :
1|FIAT|0010103|113013|01/01/1996|31/12/9999|1.15 2|231|966|0 2|232|747|0 1|FIAT|0010103|123014|01/01/2000|31/12/9999|1.15 2|232|717|0 2|232|718|0 2|232|728|0 2|232|818|0 1|FIAT|0010103|23011|01/01/2000|31/12/9999|1.15 2|232|613|1 2|234|743|1 2|234|793|1 2|234|893|1 1|FIAT|0010103|23012|01/01/2000|31/12/9999|1.15 2|230|006|0 2|230|106|0 2|230|116|0 2|230|716|0 |
|
||||
|
sorry my desired output is as below :
1|FIAT|0010103|113013|01/01/1996|31/12/9999|1.15 2|231|966|0 2|232|747|0 1|FIAT|0010103|123014|01/01/2000|31/12/9999|1.15 2|232|717|0 2|232|718|0 2|232|728|0 2|232|818|0 1|FIAT|0010103|23011|01/01/2000|31/12/9999|1.15 2|232|613|1 2|234|743|1 2|234|793|1 2|234|893|1 1|FIAT|0010103|23012|01/01/2000|31/12/9999|1.15 2|230|006|0 2|230|106|0 2|230|116|0 2|230|716|0 |
|
||||
|
Yes i have tried the command and its working
|
| Sponsored Links | ||
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|