#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    1
    Rep Power
    0

    Date and time sort using perl


    How could I do a multi sort i.e first sort by date, then sort by time, then print only the entries for todays date from the file using PERL.

    Basically, it should read the content of the file, sort the output and print only the output corresponding to todays date.

    Below is how the file looks like:

    Date Time Tag
    08-13-2013 19:22:16 Yes
    08-13-2013 18:22:17 No
    08-13-2013 21:22:17 Yes
    08-13-2013 20:22:16 Yes
    08-13-2013 23:22:18 Yes
    08-13-2013 22:22:17 No
    08-14-2013 01:22:17 Yes
    08-14-2013 00:22:18 Yes
    08-14-2013 03:22:19 No
    08-14-2013 02:22:18 Yes
    08-14-2013 05:22:28 No
    08-14-2013 04:22:29 Yes
    08-14-2013 07:22:19 Yes
    08-14-2013 06:22:18 Yes
    08-14-2013 09:22:19 No
    08-14-2013 08:22:19 Yes
    08-14-2013 11:22:19 Yes
    08-14-2013 10:22:20 No
    08-14-2013 13:22:20 Yes
    08-14-2013 12:22:20 No
    08-14-2013 15:22:21 Yes
    08-14-2013 14:22:20 Yes
    08-14-2013 17:22:21 Yes
    08-14-2013 16:22:22 No

    The output needs to be sorted by date first and then by time.Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2012
    Posts
    832
    Rep Power
    496
    This has already been answered on your cross post on Perl Monks.

    The bottom line is that if you are going to keep only the records from today's date, then you don't need to sort the records on dates, the date will all be the same. You should actually filter out the other records prior to sorting, this will be less work for the computer.

IMN logo majestic logo threadwatch logo seochat tools logo