Sponsored Content
Top Forums Shell Programming and Scripting shell script to sort entries in a file by date and time Post 302501629 by clx on Friday 4th of March 2011 04:45:36 AM
Old 03-04-2011
Its working for me.

Code:
$ sort -k6.7,6.8 -k6.1,6.2 -k6.4,6.5 -k7.1,7.2 -k7.4,7.5 -k7.7,7.8 < f
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 01/01/10 02:00:10
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 02/02/10 04:01:11
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 02/11/11 04:11:22
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 03/12/11 05:12:33
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 04/21/11 06:20:40
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 05/22/11 06:22:45
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 06/28/11 07:40:65
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 07/29/11 08:44:77
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 08/30/11 08:66:80
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 09/30/11 11:80:82
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 10/31/11 11:91:95
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 11/32/11 33:92:99
$ 
$ 
$ cat f
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 09/30/11 11:80:82
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 05/22/11 06:22:45
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 11/32/11 33:92:99
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 02/11/11 04:11:22
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 01/01/10 02:00:10
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 02/02/10 04:01:11
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 07/29/11 08:44:77
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 03/12/11 05:12:33
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 04/21/11 06:20:40
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 10/31/11 11:91:95
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 08/30/11 08:66:80
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 06/28/11 07:40:65
$

Sorry if I am unable to find the difference.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute a part of shell script only after particular date and time

I have created a simple shell script... say test.sh Contents of test.sh ================ service named restart cp /etc/imp.conf /backup/test/ #-- if date > 15 July 2007 11:23 pm , then only issue the commans below, else exit --- cp /etc/secondimp.conf /backup/test/ rm -f... (2 Replies)
Discussion started by: fed.linuxgossip
2 Replies

2. Shell Programming and Scripting

Sort By Date and Time

Hi , I would like to list or sort by date and time (the files are named in day and time format) where the latest file will be placed at the bottom and the earliest file be placed at the top. Can anybody help me? My files are named in the following manner. EG: abc_071128_144121_data "... (21 Replies)
Discussion started by: Raynon
21 Replies

3. Shell Programming and Scripting

Is it possible to get the date and time of mail which we get into our inbox using shell script?

Hello All, I need a script which extarct the date and time of the mail which is there in our inbox... I can export the mail copy into desktop making it as a textfile or something like that.. So is there anyway to get the date and time from that? (3 Replies)
Discussion started by: smarty86
3 Replies

4. Shell Programming and Scripting

Date and Time comparison using shell script

Hi, I'm having two fields in the file F1|F2 20111220|102000 F1 ->YYYYMMDD F2 ->HHMMSS Now, I need to compare this with current date & time and need to return the difference value in hours. Already, I checked with datecalc from the forum. So, need hints from Shell Gurus. Thanks (10 Replies)
Discussion started by: buzzusa
10 Replies

5. Shell Programming and Scripting

How to Sort by Date and Time?

Hi, The input file is as follows, 22.06.2012 17:58:38 CPUser: xxxxxxx, billedAfterStatus: Active 13.07.2012 08:46:15 CPUser: xxxxxxx, billedAfterStatus: Active 20.07.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active 20.03.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active... (16 Replies)
Discussion started by: nanthagopal
16 Replies

6. Shell Programming and Scripting

How to do simple date (time) calculation in shell script?

Hi, I'm looking for a way to do a simple math calc during a shell script as a means of logging how long a particular task takes. For example... STARTTIME=whenever this script starts ./path/to/command.sh >>logfile.log TOTALTIME=<time at this stage of the script after above command... (7 Replies)
Discussion started by: nbsparks
7 Replies

7. Shell Programming and Scripting

Date / Time difference in shell script

================================================================================ Request ID GMDCOM TIME GMDRRS TIME COM-RRS ================================================================================ <36812974> Tue Oct 1 13:32:40 2013 Tue Oct 1 20:36:42 2013... (1 Reply)
Discussion started by: ghosh_tanmoy
1 Replies

8. Shell Programming and Scripting

Date / Time difference in shell script

Request ID GMDCOMTM GMDRRSTIME GMDRESTIME <36812986> : : :I want to display the date -time difference in other fields. Above I have given for only 1 record. I want to calculate for all the records. (GMCOMTM - GMDRRSTM) ,(GMDRRSTM-GMDRESTM) and... (5 Replies)
Discussion started by: ghosh_tanmoy
5 Replies

9. Shell Programming and Scripting

Date time difference in UNIX shell script

There are 2 dates, Tue Oct 1 13:40:19 2013 Sun Sept 30 10:26:23 2013 I have multiple dates like the above one. How do I calculate the date time difference and display in another column in Shell script. Please help. (3 Replies)
Discussion started by: tanmoysays
3 Replies

10. Shell Programming and Scripting

Shell Script | Parse log file after a given date and time stamp

I am developing one script which will take log file name, output file name, date, hour and minute as an argument and based on these inputs, the script will scan and capture all the error(s) that have been triggered from a given time. Example: script should capture all the error after 13:50 on Jan... (2 Replies)
Discussion started by: ROMA3
2 Replies
xlator_call(8)						      System Manager's Manual						    xlator_call(8)

Name
       xlator_call - shell script to invoke PostScript translators

Syntax
       xlator_call datatype orientation pagesize width length indent

Description
       This  Bourne  shell script can be called by the line printer daemon to invoke the appropriate translator to convert each data type to Post-
       Script.	The data type passed by may be specified by using the command with the -Ddatatype option, or by using the  Da=datatype	capability
       in the file.

       For a file in a data syntax to be translated to PostScript, the script must contain a case branch which recognizes the data type string and
       calls a suitable filter.  The supplied recognizes the ANSI, ASCII, ReGIS and Tektronix 4014 data types.

Arguments
       datatype
       The valid data types are: or any other for which a translator has been installed.

       orientation
       The valid orientations are: portrait or landscape.

       pagesize
       The valid page sizes are: or

       width
       The width (in characters) of the page.

       length
       The length (in lines) of the page.

       indent
       The amount (in spaces) the output is to be indented.

       All the valid arguments are described in detail by the reference page.

Examples
       An example shell script is shown below:
       case $datatype in
       ansi)
	    exec ansi_ps -F $pagesize -O $orientation -e "$@";;
       ascii)
	    echo "(04) cvn {} def"
	    exec ln03rof -w$width -l$length -i$indent;;
       postscript)
	    exec cat;;
       tek4014)
	    exec tek4014_ps -F $pagesize -O $orientation;;
       regis)
	    exec regis_ps -F $pagesize -O $orientation;;
       *)
	    echo "$0: Translator for data type $datatype not installed" >&2
       esac

       When the shell script is called, the path searched is:
       /usr/local/lib/lpdfilters:/usr/ucb:/bin:/usr/bin:
				   /usr/lib:/usr/lib/lpdfilters

Files
       The				       script

See Also
       lno3rof(8), printcap(5), ansi_ps(8), lpd(8)

																    xlator_call(8)
All times are GMT -4. The time now is 08:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy