|
|
|
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 |
| Regarding sorting | vivek.bharadwaj | Shell Programming and Scripting | 6 | 02-06-2009 02:59 AM |
| Need immediate help with sorting!!! | sasuke_uchiha | Shell Programming and Scripting | 9 | 08-06-2008 12:07 AM |
| Sorting in C++.. | ronix007 | High Level Programming | 6 | 03-06-2008 05:16 PM |
| Unix Arithmatic operation issue , datatype issue | thambi | Shell Programming and Scripting | 23 | 02-19-2008 07:19 AM |
| Sorting mp3 | penguin-friend | Shell Programming and Scripting | 3 | 05-13-2005 04:21 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
03-19-2009
|
||||
|
||||
|
Sorting Issue
Hi Guys,
I am very new to Unix.Can anyone tell me how to sort a file based on fields. For example, I am having a file whose contents are mentioned below: 2233|charles harris |g.m. |sales |12/12/52| 90000 9876|bill johnson |director |production|03/12/50|130000 5678|robert dylan |d.g.m. |marketing |04/19/43| 85000 2365|john woodcock |director |personnel |05/11/47|120000 Each line contains emp-id, name, designation, department, date of birth, and salary. How to sort the file on the basis of salary? How to get unique designations? Regards, Mahesh Raghunandanan |
|
03-19-2009
|
||||
|
||||
|
Type
Code:
man sort But to be brutally honest, the easiest way is to open the file in Excel (other spreadsheets will do!), split the columns and hit the Sort menu option!  |
|
03-19-2009
|
||||
|
||||
|
sort -t "|" -k 6 -n -r sortsalary.txt
9876|bill johnson |director |production|03/12/50|130000 2365|john woodcock |director |personnel |05/11/47|120000 2233|charles harris |g.m. |sales |12/12/52|90000 5678|robert dylan |d.g.m. |marketing |04/19/43|85000 |
|
03-19-2009
|
||||
|
||||
|
Code:
sort -t"|" -n -r +5 filename |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
