Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: select the lines in between some time span
Top Forums Shell Programming and Scripting select the lines in between some time span Post 302566498 by birei on Thursday 20th of October 2011 12:45:25 PM
Old 10-20-2011
Hi me_newbie,

A possible solution using 'perl':
Code:
$ cat infile 
---some text---- 01/Jan/2010 ---- some other text ----
---some text---- 10/Jan/2010 ---- some other text ----
---some text---- 20/Dec/2010 ---- some other text ----
---some text---- 01/Jan/2011 ---- some other text ----
---some text---- 02/Jan/2011 ---- some other text ----
$ cat script.pl
use warnings;
use strict;
use POSIX;

my %TAB_MONTH = ( 
        jan     =>      0,
        feb     =>      1,
        mar     =>      2,
        apr     =>      3,
        may     =>      4,
        jun     =>      5,
        jul     =>      6,
        aug     =>      7,
        sep     =>      8,
        oct     =>      9,
        nov     =>      10,
        dec     =>      11
);

die qq[Usage: perl $0 input-file date-from date-to\n] unless @ARGV == 3;

my $utc_date_to = date_str_to_utc( pop @ARGV ) or die qq[Bad format of date (dd/mmm/yyyy)\n];
my $utc_date_from = date_str_to_utc( pop @ARGV ) or die qq[Bad format of date (dd/mmm/yyyy)\n];

while ( <> ) {
        next if m/\A\s*\z/;
        chomp;
        my $utc_date_line = date_str_to_utc( $_ ) or next; 
        if ( $utc_date_line >= $utc_date_from && $utc_date_line <= $utc_date_to ) {
                printf "%s\n", $_;
        }
}


sub date_str_to_utc {
        my ($date_str) = $_[0];

        my ($mday,$month,$year) = $date_str =~ m|\b(\d{2})/(\w{3})/(\d{4})| or return;
        my $utc_date = POSIX::mktime( 0, 0, 0, $mday, $TAB_MONTH{ lc $month }, $year - 1900 );

        return $utc_date;
}
$ perl script.pl infile "09/Jan/2010" "01/Jan/2011"
---some text---- 10/Jan/2010 ---- some other text ----
---some text---- 20/Dec/2010 ---- some other text ----
---some text---- 01/Jan/2011 ---- some other text ----

Regards,
Birei
This User Gave Thanks to birei For This Post:
me_newbie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

important. select 10 files each time.

Suppose I have a unix file which contain a lost of 60 files like filename1 filename2 ... .. ... filename60 I want to write a unix script that will pick up first 10 files in first run 10-20 files in 2 run 20-30 files in 3 run 30-40 files in 4 run 40-50 files in 5 run 50-60 files in 6... (2 Replies)
Discussion started by: er_zeeshan05
2 Replies

2. UNIX for Dummies Questions & Answers

Extracting a Time Span from Syslog Messages File

Hi all, I need your help to explain how I can extract a time span from the syslog messages file on a Solaris 10 system. Here is an example extract of the syslog messages: Dec 4 11:51:38 hajap141-0107.nls.jlrint.com 267938: Dec 4 11:51:36: %DOT11-6-DISASSOC: Interface Dot11Radio0,... (4 Replies)
Discussion started by: wthomas
4 Replies

3. Shell Programming and Scripting

Select lines in which column have value greater than some percent of total file lines

i have a file in following format 1 32 3 4 6 4 4 45 1 45 4 61 54 66 4 5 65 51 56 65 1 12 32 85 now here the total number of lines are 8(they vary each time) Now i want to select only those lines in which the values... (6 Replies)
Discussion started by: vaibhavkorde
6 Replies

4. Shell Programming and Scripting

How to select/delete some lines in shell?

I need to delete half(approx) the file or select half the file by existence of some character My file looks like 1 2 3 4 . . . 50 . . 100I need to select only 50 to rest of the file or needs to delete the file upto 50. Please help me out.. (6 Replies)
Discussion started by: SujeethP
6 Replies

5. Shell Programming and Scripting

need to grep contents of a file within specific time span. regex i am using is not working

Hi , I am trying to extract contents of a file between specified time stamp. but it does not seem to work. i am trying to extract output of /var/adm/messages between 15:00:00 to 15:23:59 . i have tried two regex the first one seems to kind of work. it displays some output. the second one is... (13 Replies)
Discussion started by: chidori
13 Replies

6. Shell Programming and Scripting

Select files by time stamp

Hi, I need help to read file in a directory on basis of time stamp. e.g. If file access in last 2 minutes it should not be copy to remote directory. Below is my script. +++++++++++++++++++++++++ #!/bin/ksh DATE=`date +"%Y-%m-%d_%H%M"` SEPARATER=" " exec < out_interfaces.cfg... (1 Reply)
Discussion started by: qamar.alam
1 Replies

7. UNIX for Dummies Questions & Answers

How to randomly select lines from a text file

I have a text file with 1000 lines, I want to randomly select 200 lines from it and print them as output. How do I go about doing that? Thanks! (7 Replies)
Discussion started by: evelibertine
7 Replies

8. Shell Programming and Scripting

Select lines where at least x columns above threshold value

I have a file with 20 columns. I'd like to retain only the lines for which the values in at least x columns, looking only at columns 6-20, are above a threshold. For example, I'd like to retain only the lines in the file below that have at least 8 columns (again, looking only at columns 6-20)... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

9. Shell Programming and Scripting

Combine logs span across multiple lines

Hi All, I am having a log file ERROR 2016-12-08 10:22:23.542 some data **** some data****** **** some data****** **** some data****** DEBUG 2016-12-08 10:23:23.542 some data **** some data****** **** some data****** **** some data****** when i grep the log file with ERROR am getting... (3 Replies)
Discussion started by: mohanalakshmi
3 Replies

10. UNIX for Beginners Questions & Answers

Total size utilizes by the files older than a time span

Through find command I identified the files older that 1 year. I need the overall size utilizes by these 1 year older files. Please share me the command to identify it .Thanks Please post in an adequate technical forum! (3 Replies)
Discussion started by: Sang
3 Replies

LEARN ABOUT DEBIAN

datetime::locale::ia

DateTime::Locale::ia(3pm)				User Contributed Perl Documentation				 DateTime::Locale::ia(3pm)

NAME

       DateTime::Locale::ia - DateTime locale package for "ia"

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'ia' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Interlingua.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 lunedi
	 martedi
	 mercuridi
	 jovedi
	 venerdi
	 sabbato
	 dominica

       Abbreviated (format)

	 lun
	 mar
	 mer
	 jov
	 ven
	 sab
	 dom

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 lunedi
	 martedi
	 mercuridi
	 jovedi
	 venerdi
	 sabbato
	 dominica

       Abbreviated (stand-alone)

	 lun
	 mar
	 mer
	 jov
	 ven
	 sab
	 dom

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 januario
	 februario
	 martio
	 april
	 maio
	 junio
	 julio
	 augusto
	 septembre
	 octobre
	 novembre
	 decembre

       Abbreviated (format)

	 jan
	 feb
	 mar
	 apr
	 mai
	 jun
	 jul
	 aug
	 sep
	 oct
	 nov
	 dec

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 januario
	 februario
	 martio
	 april
	 maio
	 junio
	 julio
	 augusto
	 septembre
	 octobre
	 novembre
	 decembre

       Abbreviated (stand-alone)

	 jan
	 feb
	 mar
	 apr
	 mai
	 jun
	 jul
	 aug
	 sep
	 oct
	 nov
	 dec

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 1-me trimestre
	 2-nde trimestre
	 3-tie trimestre
	 4-te trimestre

       Abbreviated (format)

	 T1
	 T2
	 T3
	 T4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 1-me trimestre
	 2-nde trimestre
	 3-tie trimestre
	 4-te trimestre

       Abbreviated (stand-alone)

	 T1
	 T2
	 T3
	 T4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 ante Christo
	 post Christo

       Abbreviated

	 a.Chr.
	 p.Chr.

       Narrow

	 a.Chr.
	 p.Chr.

   Date Formats
       Full

	  2008-02-05T18:30:30 = martedi, 2008 februario 05
	  1995-12-22T09:05:02 = venerdi, 1995 decembre 22
	 -0010-09-15T04:44:23 = sabbato, -10 septembre 15

       Long

	  2008-02-05T18:30:30 = 2008 februario 5
	  1995-12-22T09:05:02 = 1995 decembre 22
	 -0010-09-15T04:44:23 = -10 septembre 15

       Medium

	  2008-02-05T18:30:30 = 2008 feb 5
	  1995-12-22T09:05:02 = 1995 dec 22
	 -0010-09-15T04:44:23 = -10 sep 15

       Short

	  2008-02-05T18:30:30 = 08/02/05
	  1995-12-22T09:05:02 = 95/12/22
	 -0010-09-15T04:44:23 = -10/09/15

       Default

	  2008-02-05T18:30:30 = 2008 feb 5
	  1995-12-22T09:05:02 = 1995 dec 22
	 -0010-09-15T04:44:23 = -10 sep 15

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = martedi, 2008 februario 05 18:30:30 UTC
	  1995-12-22T09:05:02 = venerdi, 1995 decembre 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = sabbato, -10 septembre 15 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 2008 februario 5 18:30:30 UTC
	  1995-12-22T09:05:02 = 1995 decembre 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = -10 septembre 15 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 2008 feb 5 18:30:30
	  1995-12-22T09:05:02 = 1995 dec 22 09:05:02
	 -0010-09-15T04:44:23 = -10 sep 15 04:44:23

       Short

	  2008-02-05T18:30:30 = 08/02/05 18:30
	  1995-12-22T09:05:02 = 95/12/22 09:05
	 -0010-09-15T04:44:23 = -10/09/15 04:44

       Default

	  2008-02-05T18:30:30 = 2008 feb 5 18:30:30
	  1995-12-22T09:05:02 = 1995 dec 22 09:05:02
	 -0010-09-15T04:44:23 = -10 sep 15 04:44:23

   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 ven
	 -0010-09-15T04:44:23 = 15 sab

       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 p.m.
	  1995-12-22T09:05:02 = 9:05 a.m.
	 -0010-09-15T04:44:23 = 4:44 a.m.

       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 p.m.
	  1995-12-22T09:05:02 = 9:05:02 a.m.
	 -0010-09-15T04:44:23 = 4:44:23 a.m.

       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 = ven, 12-22
	 -0010-09-15T04:44:23 = sab, 9-15

       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 = ven dec 22
	 -0010-09-15T04:44:23 = sab sep 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = februario 5
	  1995-12-22T09:05:02 = decembre 22
	 -0010-09-15T04:44:23 = septembre 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = mar februario 5
	  1995-12-22T09:05:02 = ven decembre 22
	 -0010-09-15T04:44:23 = sab septembre 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 = ven, 1995-12-22
	 -0010-09-15T04:44:23 = sab, -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 = ven, 1995 dec 22
	 -0010-09-15T04:44:23 = sab, -10 sep 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 februario
	  1995-12-22T09:05:02 = 1995 decembre
	 -0010-09-15T04:44:23 = -10 septembre

       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 T1
	  1995-12-22T09:05:02 = 1995 T4
	 -0010-09-15T04:44:23 = -10 T3

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       lunedi

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.10.1							    2010-03-19						 DateTime::Locale::ia(3pm)
All times are GMT -4. The time now is 07:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy