Sponsored Content
Full Discussion: Sort in chronological order
Top Forums UNIX for Beginners Questions & Answers Sort in chronological order Post 303017375 by Don Cragun on Tuesday 15th of May 2018 01:41:58 AM
Old 05-15-2018
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:
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. UNIX for Advanced & Expert Users

Uploading files in chronological order

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

7. 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

8. 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

9. 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

10. 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
condor_history(1)					      General Commands Manual						 condor_history(1)

Name
       condor_history View - log of Condor jobs completed to date

Synopsis
       condor_history [-help]

       condor_history[-backwards]  [-forwards]	[-constraint  expr] [-f filename] [-format formatString AttributeName] [-l | -long | -xml] [-match
       number] [cluster | cluster.process | owner]

Description
       condor_history displays a summary of all Condor jobs listed in the specified history files. If no history  files  are  specified  with  the
       -foption,  the local history file as specified in Condor's configuration file (	$(SPOOL) /history by default) is read. The default listing
       summarizes in reverse chronological order each job on a single line, and contains the following items:

       ID

	  The cluster/process id of the job.

       OWNER

	  The owner of the job.

       SUBMITTED

	  The month, day, hour, and minute the job was submitted to the queue.

       RUN_TIME

	  Remote wall clock time accumulated by the job to date in days, hours, minutes, and seconds. See the definition  of   RemoteWallClockTime
	  on page .

       ST

	  Completion status of the job (C = completed and X = removed).

       COMPLETED

	  The time the job was completed.

       CMD

	  The name of the executable.

       If  a  job ID (in the form of cluster_idor cluster_id.proc_id) or an owneris provided, output will be restricted to jobs with the specified
       IDs and/or submitted by the specified owner. The -constraintoption can be used to display jobs that satisfy a specified boolean expression.

       The history file is kept in chronological order, implying that new entries are appended at the end  of  the  file.  As  of  Condor  version
       6.7.19,	the  format of the history file is altered to enable faster reading of the history file backwards (most recent job first). History
       files written with earlier versions of Condor, as well as those that have entries of both the older and newer format need to  be  converted
       to the new format. See the condor_convert_historymanual page on page for details on converting history files to the new format.

Options
       -help

	  Display usage information and exit.

       -backwards

	  List jobs in reverse chronological order. The job most recently added to the history file is first. This is the default ordering.

       -forwards

	  List jobs in chronological order. The job most recently added to the history file is last.

       -constraint expr

	  Display jobs that satisfy the expression.

       -f filename

	  Use the specified file instead of the default history file.

       -format formatStringAttributeName

	  Display jobs with a custom format. See the condor_qman page -formatoption for details.

       -lor -long

	  Display job ClassAds in long format.

       -match number

	  Limit the number of jobs displayed to number.

       -xml

	  Display job ClassAds in xml format. The xml format is fully defined at http://www.cs.wisc.edu/condor/classad/refman/.

Exit Status
       condor_historywill exit with a status value of 0 (zero) upon success, and it will exit with the value 1 (one) upon failure.

Author
       Condor Team, University of Wisconsin-Madison

Copyright
       Copyright  (C)  1990-2012  Condor  Team,  Computer  Sciences Department, University of Wisconsin-Madison, Madison, WI. All Rights Reserved.
       Licensed under the Apache License, Version 2.0.

       See the Condor Version 7.8.2 Manualor http://www.condorproject.org/licensefor additional notices. condor-admin@cs.wisc.edu

								  September 2012						 condor_history(1)
All times are GMT -4. The time now is 12:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy