Sponsored Content
Top Forums Shell Programming and Scripting Sort content of text file based on date? Post 302493322 by radoulov on Wednesday 2nd of February 2011 10:52:33 AM
Old 02-02-2011
Adjust the months names Smilie

Code:
perl -ne'BEGIN {
  @m{
    qw[ jan feb mar apr maj jun jul aug sep oct nov dec ]
    } = 1 .. 12;
  } 
/^(\d+) (\w+) (\d+) (\d+):(\d+)/ and
  $d = join "", sprintf "%d%02d%02d%02d%02d", 
    $3, $m{$2}, $1, $4, $5;
  do {
    push @r, [$d, $r]; 
    undef $r; 
    next;
    } if /^---/;      
  $r .= $_;     
  END {
    print map {
      $_->[1] . ("-") x 50 . $/ 
      } sort { 
        $a->[0] <=> $b->[0] 
        } @r;
   }' infile

This User Gave Thanks to radoulov For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort file text by date as a "ls -t"

I have, a file wich list file on server ftp and i want to sort the file text as the command "ls -t" i.e drwxr-x--- 2 ftp_mont System 0 Sep 30 09:16 . drwxr-x--- 2 ftp_mont System 0 Jul 15 2009 .. -rwxr-x--- 1 ftp_mont System 343998791 Sep 01 09:20 manif... (14 Replies)
Discussion started by: protocomm
14 Replies

2. Shell Programming and Scripting

Help with allocated text content based on specific rules...

Input file format: /tag="ABL" /note="abl homolog 2 /tag="ABLIM1" /note="actin binding LIM 1 /tag="ABP1" /note="amiloride binding protein 1 (amine oxidase (copper- containing)) /tag="ABR" /note="active BCR-related /tag="AC003042.1" /note="SDR family member 11 precursor . . . (4 Replies)
Discussion started by: perl_beginner
4 Replies

3. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

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)
Discussion started by: rveri
3 Replies

4. Shell Programming and Scripting

Sort a file content with space

Hello, I need help on. I have a File which stores the information as below. It is space separated file, I want to keep only unique record in file based on file name. Also if you notice sometime filename with space appear in last column like (abc_ xyz1_bc12_20140312_c.xlsx) 03/17/2014 ... (9 Replies)
Discussion started by: kumar30213
9 Replies

5. Shell Programming and Scripting

Sort a file content using one column

Hello All, I have a file which have content as below. 03/09/2014 10:35 AM 618 Admin\rick pqr_ klm2_pog12_20140309_c.xlsx 03/10/2014 10:35 AM 618 user\test01 mplz_ fgh2_lal12_20140310_c.xlsx 03/17/2014 10:35 AM 618 Admin\vick abc_ xyz2_bc12_20140317_c.xlsx 03/18/2014 ... (2 Replies)
Discussion started by: kumar30213
2 Replies

6. Shell Programming and Scripting

Sort outlook dump of emails based on date

Greetings! I have an export of an outlook database in text format. The emails however did not export by date and are all scattered in a massive file. I am hoping somebody out there could help me with a command that could sort the file based on the date. Here is the format of the email... (2 Replies)
Discussion started by: tntelle
2 Replies

7. UNIX for Dummies Questions & Answers

How to sort a content of a text file using a shell script?

I am new to shell scripting. I am interested how to know how to sort a content of a file using shell scripting. I've attached the 'Input file' and the 'expected output' to this thread. Details provided in the expected output file will provide details on how the sort needs to be done. ... (16 Replies)
Discussion started by: nkarthik_mnnit
16 Replies

8. Shell Programming and Scripting

How to Modify a file content in UNIX and sort for only required fields ?

I have the below contents in a file after making the below curl call curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "Disconnected" > test "state" : "Disconnected",, "Rno" : "5554f1d2" "state" : "Disconnected",, "Rno" : "10587563" "state" : "Disconnected",, "Rno" :... (2 Replies)
Discussion started by: Vaibhav H
2 Replies

9. Shell Programming and Scripting

Sort html based on .jar, .war file names and still keep text within three groups.

Output from zipdiff GNU EAR comparison tool produces output in html divided into three sections "Added, Removed, Changed". I want the output to be sorted by jar or war file. <html> <body> <table> <tr> <td class="diffs" colspan="2">Added </td> </tr> <tr><td> <ul>... (5 Replies)
Discussion started by: kchinnam
5 Replies

10. UNIX for Beginners Questions & Answers

Sort a text file based on names in square brackets

Hi all, I have a text file similar to this: Text More text Etc Stuff That Is Needed Etc Etc This contains over 70 entries and each entry has several lines of text below the name in square brackets. (5 Replies)
Discussion started by: Scally
5 Replies
DateTime::Locale::kl(3) 				User Contributed Perl Documentation				   DateTime::Locale::kl(3)

NAME
DateTime::Locale::kl SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'kl' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Kalaallisut. DATA
This locale inherits from the DateTime::Locale::root locale. It contains the following data. Days Wide (format) ataasinngorneq marlunngorneq pingasunngorneq sisamanngorneq tallimanngorneq arfininngorneq sabaat Abbreviated (format) ata mar pin sis tal arf sab Narrow (format) 2 3 4 5 6 7 1 Wide (stand-alone) ataasinngorneq marlunngorneq pingasunngorneq sisamanngorneq tallimanngorneq arfininngorneq sabaat Abbreviated (stand-alone) ata mar pin sis tal arf sab Narrow (stand-alone) 2 3 4 5 6 7 1 Months Wide (format) januari februari martsi aprili maji juni juli augustusi septemberi oktoberi novemberi decemberi Abbreviated (format) jan feb mar apr maj jun jul aug sep okt nov dec Narrow (format) 1 2 3 4 5 6 7 8 9 10 11 12 Wide (stand-alone) januari februari martsi aprili maji juni juli augustusi septemberi oktoberi novemberi decemberi Abbreviated (stand-alone) jan feb mar apr maj jun jul aug sep okt nov dec Narrow (stand-alone) 1 2 3 4 5 6 7 8 9 10 11 12 Quarters Wide (format) Q1 Q2 Q3 Q4 Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) Q1 Q2 Q3 Q4 Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide BCE CE Abbreviated BCE CE Narrow BCE CE Date Formats Full 2008-02-05T18:30:30 = marlunngorneq 05 februari 2008 1995-12-22T09:05:02 = tallimanngorneq 22 decemberi 1995 -0010-09-15T04:44:23 = arfininngorneq 15 septemberi -10 Long 2008-02-05T18:30:30 = 05 februari 2008 1995-12-22T09:05:02 = 22 decemberi 1995 -0010-09-15T04:44:23 = 15 septemberi -10 Medium 2008-02-05T18:30:30 = feb 05, 2008 1995-12-22T09:05:02 = dec 22, 1995 -0010-09-15T04:44:23 = sep 15, -10 Short 2008-02-05T18:30:30 = 05/02/08 1995-12-22T09:05:02 = 22/12/95 -0010-09-15T04:44:23 = 15/09/-10 Default 2008-02-05T18:30:30 = feb 05, 2008 1995-12-22T09:05:02 = dec 22, 1995 -0010-09-15T04:44:23 = sep 15, -10 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 PM UTC 1995-12-22T09:05:02 = 9:05:02 AM UTC -0010-09-15T04:44:23 = 4:44:23 AM UTC Long 2008-02-05T18:30:30 = 6:30:30 PM UTC 1995-12-22T09:05:02 = 9:05:02 AM UTC -0010-09-15T04:44:23 = 4:44:23 AM UTC Medium 2008-02-05T18:30:30 = 6:30:30 PM 1995-12-22T09:05:02 = 9:05:02 AM -0010-09-15T04:44:23 = 4:44:23 AM Short 2008-02-05T18:30:30 = 6:30 PM 1995-12-22T09:05:02 = 9:05 AM -0010-09-15T04:44:23 = 4:44 AM Default 2008-02-05T18:30:30 = 6:30:30 PM 1995-12-22T09:05:02 = 9:05:02 AM -0010-09-15T04:44:23 = 4:44:23 AM Datetime Formats Full 2008-02-05T18:30:30 = marlunngorneq 05 februari 2008 6:30:30 PM UTC 1995-12-22T09:05:02 = tallimanngorneq 22 decemberi 1995 9:05:02 AM UTC -0010-09-15T04:44:23 = arfininngorneq 15 septemberi -10 4:44:23 AM UTC Long 2008-02-05T18:30:30 = 05 februari 2008 6:30:30 PM UTC 1995-12-22T09:05:02 = 22 decemberi 1995 9:05:02 AM UTC -0010-09-15T04:44:23 = 15 septemberi -10 4:44:23 AM UTC Medium 2008-02-05T18:30:30 = feb 05, 2008 6:30:30 PM 1995-12-22T09:05:02 = dec 22, 1995 9:05:02 AM -0010-09-15T04:44:23 = sep 15, -10 4:44:23 AM Short 2008-02-05T18:30:30 = 05/02/08 6:30 PM 1995-12-22T09:05:02 = 22/12/95 9:05 AM -0010-09-15T04:44:23 = 15/09/-10 4:44 AM Default 2008-02-05T18:30:30 = feb 05, 2008 6:30:30 PM 1995-12-22T09:05:02 = dec 22, 1995 9:05:02 AM -0010-09-15T04:44:23 = sep 15, -10 4:44:23 AM Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 mar 1995-12-22T09:05:02 = 22 tal -0010-09-15T04:44:23 = 15 arf Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 PM 1995-12-22T09:05:02 = 9:05 AM -0010-09-15T04:44:23 = 4:44 AM Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 PM 1995-12-22T09:05:02 = 9:05:02 AM -0010-09-15T04:44:23 = 4:44:23 AM M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (M-d) 2008-02-05T18:30:30 = 2-5 1995-12-22T09:05:02 = 12-22 -0010-09-15T04:44:23 = 9-15 MEd (E, M-d) 2008-02-05T18:30:30 = mar, 2-5 1995-12-22T09:05:02 = tal, 12-22 -0010-09-15T04:44:23 = arf, 9-15 MMdd (dd/MM) 2008-02-05T18:30:30 = 05/02 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/09 MMM (LLL) 2008-02-05T18:30:30 = feb 1995-12-22T09:05:02 = dec -0010-09-15T04:44:23 = sep MMMd (MMM d) 2008-02-05T18:30:30 = feb 5 1995-12-22T09:05:02 = dec 22 -0010-09-15T04:44:23 = sep 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = mar feb 5 1995-12-22T09:05:02 = tal dec 22 -0010-09-15T04:44:23 = arf sep 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = februari 5 1995-12-22T09:05:02 = decemberi 22 -0010-09-15T04:44:23 = septemberi 15 MMMMdd (dd MMMM) 2008-02-05T18:30:30 = 05 februari 1995-12-22T09:05:02 = 22 decemberi -0010-09-15T04:44:23 = 15 septemberi MMMMEd (E MMMM d) 2008-02-05T18:30:30 = mar februari 5 1995-12-22T09:05:02 = tal decemberi 22 -0010-09-15T04:44:23 = arf septemberi 15 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = mar, 2008-2-5 1995-12-22T09:05:02 = tal, 1995-12-22 -0010-09-15T04:44:23 = arf, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 feb 1995-12-22T09:05:02 = 1995 dec -0010-09-15T04:44:23 = -10 sep yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = mar, 2008 feb 5 1995-12-22T09:05:02 = tal, 1995 dec 22 -0010-09-15T04:44:23 = arf, -10 sep 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 februari 1995-12-22T09:05:02 = 1995 decemberi -0010-09-15T04:44:23 = -10 septemberi yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 Q1 1995-12-22T09:05:02 = 1995 Q4 -0010-09-15T04:44:23 = -10 Q3 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = februari 2008 1995-12-22T09:05:02 = decemberi 1995 -0010-09-15T04:44:23 = septemberi -10 Miscellaneous Prefers 24 hour time? No Local first day of the week ataasinngorneq SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.16.3 2014-06-10 DateTime::Locale::kl(3)
All times are GMT -4. The time now is 10:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy