Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

sort output

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sort output
# 8  
Old 01-11-2008
oh I see it is working, my fault Smilie

in the output I posted above, the year ist missing, the last column should be the year

host3 /etc/passwd changed Thu Dec 27 12:47:29 2007
host4 /etc/passwd changed Thu Dec 27 12:28:13 2007
host3 /etc/passwd changed Thu Dec 27 12:13:29 2007
host1 /etc/passwd changed Thu Dec 27 12:05:58 ...
host5 /etc/passwd changed Thu Dec 27 12:00:57 ...
host8 /etc/passwd changed Thu Dec 27 11:50:40
host7 /etc/security/user changed Thu Dec 27 10:34:27
host6 /etc/group changed Thu Dec 27 10:34:27
host3 /etc/security/user changed Fri Dec 21 12:25:23
host10 /etc/group changed Thu Jan 10 09:59:01
host2 /etc/security/user changed Tue Jan 8 13:15:02
host11 /etc/group changed Thu Jan 3 18:55:38 2008
host17 /etc/group changed Thu Jan 3 17:45:41 2008
host3 /etc/group changed Thu Jan 3 16:39:48 ...
host2 /etc/services changed Thu Jan 3 16:39:48
host16 /etc/passwd changed Thu Jan 3 16:39:48



great work vgersh99, perhaps you can modify your script, to sort after the year too?

cheers
# 9  
Old 01-11-2008
Hi.

A POSIX sort should work. Here's an example from Linux:
Code:
sort -k 8,8n -k 5,5M -k 6,6n -k 7,7

As done in the script:
Code:
#!/usr/bin/env sh

# @(#) s1       Demonstrate POSIX sort.

#  ____
# /
# |   Infrastructure BEGIN

set -o nounset
echo

debug=":"
debug="echo"

## The shebang using "env" line is designed for portability. For
#  higher security, use:
#
#  #!/bin/sh -

## Use local command version for the commands in this demonstration.

echo "(Versions displayed with local utility \"version\")"
version >/dev/null 2>&1 && version bash sort column

echo

FILE=${1-data1}
echo " Sample of input file $FILE:"
head -5 $FILE

# |   Infrastructure END
# \
#  ---

echo
echo " Results from processing:"

# Field assignments:
# 1      2           3       4   5   6 7        8
# host16 /etc/passwd changed Thu Jan 3 16:39:48 2007
# ( could be used depending on sort    12 45 78 )

sort -k 8,8n -k 5,5M -k 6,6n -k 7,7 $FILE |
column -t

exit 0

producing:
Code:
% ./s1

(Versions displayed with local utility "version")
GNU bash 2.05b.0
sort (coreutils) 5.2.1
column (local) - no version provided.

 Sample of input file data1:
host16 /etc/passwd changed Thu Jan 3 16:39:48 2008
host3 /etc/group changed Thu Jan 3 16:39:48 2008
host2 /etc/services changed Thu Jan 3 16:39:48 2008
host10 /etc/group changed Thu Jan 10 09:59:01 2008
host11 /etc/group changed Thu Jan 3 18:55:38 2008

 Results from processing:
host3   /etc/security/user  changed  Fri  Dec  21  12:25:23  2007
host6   /etc/group          changed  Thu  Dec  27  10:34:27  2007
host7   /etc/security/user  changed  Thu  Dec  27  10:34:27  2007
host8   /etc/passwd         changed  Thu  Dec  27  11:50:40  2007
host5   /etc/passwd         changed  Thu  Dec  27  12:00:57  2007
host1   /etc/passwd         changed  Thu  Dec  27  12:05:58  2007
host3   /etc/passwd         changed  Thu  Dec  27  12:13:29  2007
host4   /etc/passwd         changed  Thu  Dec  27  12:28:13  2007
host3   /etc/passwd         changed  Thu  Dec  27  12:47:29  2007
host16  /etc/passwd         changed  Thu  Jan  3   16:39:48  2008
host2   /etc/services       changed  Thu  Jan  3   16:39:48  2008
host3   /etc/group          changed  Thu  Jan  3   16:39:48  2008
host17  /etc/group          changed  Thu  Jan  3   17:45:41  2008
host11  /etc/group          changed  Thu  Jan  3   18:55:38  2008
host2   /etc/security/user  changed  Tue  Jan  8   13:15:02  2008
host10  /etc/group          changed  Thu  Jan  10  09:59:01  2008

I often forget to make sure the key specifications include the beginning and end field, e.g. -k 3,3n, to sort on field 3 numerically. If you forget the final ",3", the key will be considered to be from the beginning of field 3 to the end of line.

The inclusion of a collating sequence for months was a very good design feature from the original UNIX sort.

I piped this though column to more easily see the ordering.

See man sort (or better, info coreutils sort, if you have it) for details ... cheers, drl
# 10  
Old 01-14-2008
yep this ones works too drl, thank you for the great explanation
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Any way to sort ps output based on STIME?

Hi, This is one of the thing that am looking for when I post the question on the ps wrapper. It has since been closed as it has taken me too long to post an example. I have replaced some of the original content of the ps output. uname -a = SunOS <hostname> 5.11 11.3 sun4v sparc sun4v ... (1 Reply)
Discussion started by: newbie_01
1 Replies

2. Shell Programming and Scripting

Need to sort an output

with a command i get a long list (example) and the entrys are intended. DName=AAAAA DName=AAAAA lba=838,860,800 label=ftw_1 DName=BBBBB DName=BBBBB lba=838,860,800 label=ftw_2 DName=CCCCC ... (3 Replies)
Discussion started by: Serano
3 Replies

3. UNIX for Dummies Questions & Answers

Ls output sort on multiple column

Hi All, I have one requirement, where I need to have output of ls -l command sorted on 1) first on filename 2) last modified time ( descending ) - latest change first. I am not able to figure out how to do it.. Also I dont have a way to change Date display for ls -ltr command.. I am... (5 Replies)
Discussion started by: freakabhi
5 Replies

4. Shell Programming and Scripting

sort ps output in seconds

Now I van sort in hour-minute-second. I need in seconds ps -eo pid,etime,args --sort=start_time | grep bash Sample Output 15064 03:23 -bash I need in 03:23 in seconds (1 Reply)
Discussion started by: anil510
1 Replies

5. Shell Programming and Scripting

Sort and output to different files

Hi all! I have a comma delimited file and I'm sorting it based on fields 6, 8 and 10. The following does the job: sort -t, -nk6,10 unsorted.txt -o sorted.txt What I need to do now is to write every row containing same values on fields 6, 8 and 10 to a different file. Any ideas on how to do... (2 Replies)
Discussion started by: Tr0cken
2 Replies

6. Shell Programming and Scripting

Sort output is different with Corn

Hi, I am sorting a file, but getting different output with crontab. input file-file z Z x X y Y when I sort manually sort file x X y Y z Z (4 Replies)
Discussion started by: suresh3566
4 Replies

7. UNIX for Dummies Questions & Answers

Sort fdupes output by size

Hi I have a file that is a fdupes output. I'd like to sort the duplicated file by size. The format file is the following: 5996544 bytes each: /path1/to/file1.jpg /path2/to/file1.jpg /pathx/to/file1.jpg ... random number of lines /path999/to/file1.jpg 591910 bytes each:... (2 Replies)
Discussion started by: AdminLew
2 Replies

8. UNIX for Dummies Questions & Answers

How to sort output from find from oldest to newest?

Hi, How do I sort the output of find to provide a listing of files from oldest to newest? For example, if I do a find /tmp -type f -print I want the output to be sorted in the order of the oldest to the newest file. Thanks in advance. (2 Replies)
Discussion started by: newbie_01
2 Replies

9. UNIX for Dummies Questions & Answers

how to sort and arrange an output

ok so I have a list of names that end in either ot,om,oa. So for example DETOT MANOA DET0M DET0A MANOT SEAOT etc... I want to be able to group this list by OT, OM, OA and have the output have some headers like this and be alphabatized and if possible be in colums instead of like... (10 Replies)
Discussion started by: llsmr777
10 Replies

10. UNIX for Dummies Questions & Answers

Sort - only one field appears in output?

I'm running against a file with 1008 records like this, all beginning '4760 Slave': 4760 Slave,7,3607 ,GL ,200605,11320024 , ,GBP ,X00033 ,AI80190 ... (1 Reply)
Discussion started by: miwinter
1 Replies
Login or Register to Ask a Question