Visit The New, Modern Unix Linux Community


Sort in chronological order

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Sort in chronological order
# 1  
Sort in chronological order

I am trying to sort a log file in chronological order to identify which ones did not process and still have an old (probably yesterday's) date. This is a sample of the file:
Code:
flatf 010140 flatf Thu May 10 22:22:11 CST 2018  flats finished
flatf 010142 flatf Thu May 10 22:31:25 CST 2018  flats finished
flatf 010148 flatf Thu May 10 22:38:49 CST 2018  flats finished

I am trying to use "-M" to sort the months in order, but a command of
Code:
sort + 8 -9 -M +4 +5

doesn't appear to do anything and leaving "-M" out works except the months are in alphabetical order (Apr, Aug, Dec, etc.).
The output would be piped into a head command where the top line(s) may show a problem. What am I missing?


TIA
# 2  
Assuming that your sort utility has a -M option (which is not required in standard sort utilities), you might want to try the following:
Code:
sort -k9,9n -k5,5M -k6,6n -k7,7

to perform a numeric sort on the year, a month sort on the abbreviated month, a numeric sort on the day, and a string sort on the time. This should sort by increased timestamps except during the shift from daylight saving time to standard time where the date sort should be correct, but the timestamp sort within those dates might be wrong for two hours on those days.
These 2 Users Gave Thanks to Don Cragun For This Post:
# 3  
When I ran "man sort" I saw the "-M" option but didn't know how to implement it. Works like a charm:
Code:
flatf 010156 flatf Thu May 10 22:47:48 CST 2017  flats finished    
flatf 030118 flatf Thu Xxx 10 22:19:47 CST 2018  flats finished    
flatf 010186 flatf Thu Feb 10 22:16:21 CST 2018  flats finished    
flatf 010190 flatf Thu Mar 10 22:38:57 CST 2018  flats finished    
flatf 010165 flatf Thu Apr 10 22:29:21 CST 2018  flats finished    
flatf 010127 flatf Wed May  9 22:16:59 CST 2018  flats finished    
flatf 090938 flatf Thu May 10 22:05:02 CDT 2018  flats finished

Again, many thanks!
# 4  
How is it that the log file is not already in chronological order.
# 5  
Those log records are not created locally. If a procedure runs to completion, it over writes that record and the log files (actually one record each) should be sent to us. If the first record of a concatenated sorted log file is about 24 hours or more earlier than the second one, we have a problem.

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #700
Difficulty: Medium
In the theory of Vernadsky, the noosphere is the fifth in a succession of phases of related to the development of the Earth.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort by specific order?

Hello all I was wondering if someone has an idea how to sort by a specific order, let's say by a specific alphabet containing only 4 letters like (d,s,a,p) instead of (a,b,c....z) ?? Cheers! (6 Replies)
Discussion started by: cabrao
6 Replies

2. UNIX for Dummies Questions & Answers

Any way to get find command o/p in chronological order?

Hi friends, I am using below script to gzip files after naming them in a particular order. but I intend to name them in numerical order as per their timings(earlier updated fle with a smaller numeric extension than later updated),but this script is not working as planned. please help with... (7 Replies)
Discussion started by: Jcpratap
7 Replies

3. Shell Programming and Scripting

Sort numeric order

Hi I am using this cat substitutionFeats.txt | gawk '{$0=gensub(/\t/,"blabla",1);print}' | gawk '{print length, $0}' | sort -n | sort -r and the "sort -n" command doesn't work as expected: it leads to a wrong ordering: 64 Adjustable cuffs 64 Abrasion- 64 Abrasion pas 647 Sanitized 647... (4 Replies)
Discussion started by: louisJ
4 Replies

4. Shell Programming and Scripting

Sorting dates in chronological order

Hi forum. I'm hoping someone can help me out with this problem. I tried to search online but couldn't come up with an exact solution. I have the following data file: H|20-May-2011|MF_FF.dat|77164|731374590.96|1|1|731374590.96|76586|77164|578|2988|Y... (8 Replies)
Discussion started by: pchang
8 Replies

5. UNIX for Advanced & Expert Users

Uploading files in chronological order

Thanks for your help. (3 Replies)
Discussion started by: circuit.muni
3 Replies

6. UNIX for Dummies Questions & Answers

sort -reverse order

I need to sort the particular column only in reverse order how i can give it.. if i give the -r option the whole file is getting sorted in reverse order. 1st 2nd col 3rd C col 4th col 5th col ------------------------------------------- C... (7 Replies)
Discussion started by: sivakumar.rj
7 Replies

7. Shell Programming and Scripting

alphabetical order with out using sort command

hai, how can i sort a file alphabetically without using sort command (6 Replies)
Discussion started by: rahul801
6 Replies

8. Shell Programming and Scripting

SORT order in Unix

I am converting mainframes JCL to be used in shell on a one to one basis... when i use the sort command unix does ascii sort as a result which numbers are first followed by charecters in the Ascending sort ... but themainframes uses the EBCDIC as result gives the charecters followed by numbers in... (5 Replies)
Discussion started by: bourne
5 Replies

9. UNIX for Dummies Questions & Answers

Sort - original order .... Help

Hi all, I want to sort a file based on the number in the 9th column I've tried both of the following commands sort -k 9,9n file_to_sort.dat sort +8 -n file_to_sort.dat both resulting in the same output which does sort col 9 nummerically but it doesn't output the lines in the original... (2 Replies)
Discussion started by: olga
2 Replies

10. UNIX for Dummies Questions & Answers

Sort / ascending order

What's the command to sort a file in ascending order and redirect the output to another file? Thanks!!!!!! (1 Reply)
Discussion started by: gyik
1 Replies

Featured Tech Videos