|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`" | Lokesha | UNIX for Dummies Questions & Answers | 4 | 12-20-2007 01:52 AM |
| Debian: doubt in "top" %CPU and "sar" output | jaduks | Debian | 0 | 09-12-2007 09:05 AM |
| Weird problem with output from "date '+3600*%H+60*%M+%S' " | m223464 | Shell Programming and Scripting | 5 | 02-16-2006 12:22 PM |
| Unix "at" / "Cron" Command New Problem...Need help | Mohanraj | UNIX for Dummies Questions & Answers | 3 | 01-26-2006 08:08 PM |
| Sorting "ls" output on more than 1 column | Nicol | UNIX for Dummies Questions & Answers | 1 | 09-20-2005 08:37 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
07-31-2006
|
|||||
|
|||||
Sorting problem "sort -k 16,29 sample.txt > output.txt"
Hi all,
Iam trying to sort the contents of the file based on the position of the file. Example: $cat sample.txt 0101020060731 ## Header record 1c1 Berger Awc ANP20070201301 4000.50 1c2 Bose W G ANP20070201609 6000.70 1c2 Andy CK ANP20070201230 28000.00 1c3 Bharg ANP20070201847 9000.80 1c3 Peter Neid ANP20070201109 2000.50 1c3 Ralf Tiger ANP20070201365 4000.10 900006 ## Trailer record Where ANP*********** is the policy number and starts in the file from 16th position. I need to sort based on these policy numbers. Iam using the "Sort" Option as below: sort -k 16,29 sample.txt > output.txt But it is not sorting based on Policy numbers. Could any one help me to fix it. Many Thanks and Regards, Ganapati  |
|
07-31-2006
|
||||
|
||||
|
Turn off field separation by using a field sep character that does not occur in any record. Try the : character, then everything is in field1
Code:
sort -t: -k 1.16,1.29 sample.txt > output.txt |
|
08-01-2006
|
||||
|
||||
|
the -k option requires m.n
m= field number n = character position You are missiing character positions. Use -k2.1,2.10 or something. |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
