To sort dates it works best to convert them to epoch seconds - the number of seconds since Jan 1 970. This code adds an epoch time sorts based on the epoch time, then prints the original minus the seconds: this assumes some kin of linux OS -
Called a tag sort.
I get this output: --- Post updated at 17:16 ---
@Drl - one of our senior people, may mention getting a linux package for date operations, one of the commands is "dsort" which does exactly what the code above does. Hopefully he will mention where to download it. I do not know
These 2 Users Gave Thanks to jim mcnamara For This Post:
I check the man page but I still cannot see what this command is supposed to do
sort +5 -6 <file>
It just seems to sort the file as normal??
Thanks
Calypso (3 Replies)
Hi to all.
I'm trying to sort this with the Unix command sort.
user1:12345678:3.5:2.5:8:1:2:3
user2:12345679:4.5:3.5:8:1:3:2
user3:12345687:5.5:2.5:6:1:3:2
user4:12345670:5.5:2.5:5:3:2:1
user5:12345671:2.5:5.5:7:2:3:1
I need to get this:
user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
sort --random-sort
The full command is
path=`find /testdir -maxdepth 1 -mindepth 1 -type d | ***Some sort of sort function*** | head -1`
I have a list I want to randomly sort. It works fine in ubuntu but on a 'osx lion' sort dosen't have the --random-sort option.
I don't want to... (5 Replies)
Input file:
100%ABC2 3.44E-12 USA
A2M%H02579 0E0 UK
100%ABC2 5.34E-8 UK
100%ABC2 3.25E-12 USA
A2M%H02579 5E-45 UK
Output file:
100%ABC2 3.44E-12 USA
100%ABC2 3.25E-12 USA
100%ABC2 5.34E-8 UK
A2M%H02579 0E0 UK
A2M%H02579 5E-45 UK
Code try:
sort -k1,1 -g -k2 -r input.txt... (2 Replies)
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
Hi,
Could anyone kindly show me a link or explain the difference between
sort -n -k2 -k3 & sort -n -k2,3
Also, if I like to remove the row with repetition at both $2 and $3, Can I safely use
sort -u -k2 -k3
Example;
100 20 30
100 20 30
So, both $2 and $3 are same and I... (2 Replies)
How to sort the following output based on lowest to highest BE?
The following sort does not work.
$ sort -t. -k1,1n -k2,2n bfd.txt
BE31.116 0s 0s DOWN DAMP
BE31.116 0s 0s DOWN DAMP
BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies
LEARN ABOUT DEBIAN
lire::time
Time(3pm) LogReport's Lire Documentation Time(3pm)NAME
Lire::Time - parses and prints date in formats common to many log files.
SYNOPSIS
use Lire::Time qw/ syslog2cal /;
my @ltime = localtime;
while ( <LOGFILE> ) {
#...
my $time = syslog2cal( $m, $d, $t, @ltime );
}
DESCRIPTION
This module supplies many functions to parse dates in formats that you are likely to encounter in log files. It also offers many functions
to format epoch time in useful format.
NOTE ABOUT FUNCTION EXPORT
Altough all documented functions are exported by default to the caller namespace, you should explicitely import the functions you require
since exporting by default isn't recommanded by the perl modules guidelines.
DATE PARSING FUNCTIONS
This module includes several functions that convert between a more human readable date format and UNIX epoch time. All parsing functions
will return the number of seconds since Jan 1 1970 00:00:00 UTC and will die() when passed invalid arguments.
date2cal()
my $time = date2cal( $year, $month, $day, $time, [$timezone] );
my $time = date2cal( "2001 Mar 20 09:32:29 +0100" );
This function will convert a date in the date(1) default output format to UNIX epoch time. The function accepts either the date in a string
or splitted on whitespace. If the timezone component is omitted, the local timezone is assumed (usually based on the value of the TZ
environment variable).
syslog2cal()
my $time = syslog2cal( $month, $day, $time, $local_tm_ref );
my $time = syslog2cal( "Mar 11 13:21:00", $local_tm_ref );
This function will convert a date in the syslog default output format to UNIX epoch time. The function accepts either the date in a string
or splitted on whitespace.
Since the syslog format doesn't contain timezone information, the local timezone is assumed (usually determined by the TZ environment
variable).
The last argument is a reference to an array returned by localtime().
my $local_tm_ref = [localtime()];
It is used to determine the year.
clf2cal()
my $time = clf2cal( "[18/Mar/2001:15:59:30 +0100]" );
This function will convert a date as found in Common Log Format to UNIX epoch time.
DATE FORMATING FUNCTIONS
This module includes some functions to convert date in UNIX epoch time to some more human readable output. All functions will die() when
passed invalid arguments.
cal2rfc()
print cal2rfc( $time );
This function will convert a date in UNIX epoch time to the RFC822 format (used in email, for example). A RFC822 date looks like
Wed, 30 May 2001 12:45:13 +0000
The timezone offset specification will correspond to the local timezone (usually determined by the TZ environment variable).
cal2ymdhms()
print cal2ymdhms( $time );
This function converts a date in UNIX epoch time to a string of the form:
YYYYMMDDHHMMSS
This representation will correspond the time in the local timezone (usually determined by the TZ environment variable.)
getMonthName()
print getMonthName( 0 ); # Gives 'Jan'
This function takes as parameter a number (0-11) representing the month (as returned by localtime() for example) and will return the
English abbreviated name of that month ( Jan, Feb, etc. ).
AUTHOR
Joost van Baal <joostvb@logreport.org>
VERSION
$Id: Time.pm,v 1.10 2006/07/23 13:16:30 vanbaal Exp $
COPYRIGHT
Copyright (C) 2000-2002 Stichting LogReport Foundation LogReport@LogReport.org
This file is part of Lire.
Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
Lire 2.1.1 2006-07-23 Time(3pm)