How to get data between the start time and end time? Post: 302297968

Sponsored Content

Top Forums Shell Programming and Scripting How to get data between the start time and end time? Post 302297968 by tanit on Monday 16th of March 2009 10:07:51 AM

03-16-2009

Registered User

How to get data between the start time and end time?

Hi,

Can anyone help me how can I get the line that between the start time and end time.

file1.txt
15/03/2009 20:45:03 Request: - Data of this line
15/03/2009 20:45:12 Response: - Data of this line
15/03/2009 22:10:40 Request: - Data of this line
15/03/2009 22:10:42 Response: - Data of this line
16/03/2009 02:05:03 Request: - Data of this line
16/03/2009 02:05:12 Response: - Data of this line
16/03/2009 08:59:57 Request: - Data of this line
16/03/2009 09:00:01 Response: - Data of this line
16/03/2009 10:45:23 Request: - Data of this line
16/03/2009 10:45:32 Response: - Data of this line

I like the users to put date and time of starting time and end time like this
$ ReportData.sh 15/03/2009 21:00:00 16/03/2009 09:00:00 and get the result. I also want Response eventhough it is over 9 o'clock since Request was before 9.
Output:
15/03/2009 22:10:40 Request: - Data of this line
15/03/2009 22:10:42 Response: - Data of this line
16/03/2009 02:05:03 Request: - Data of this line
16/03/2009 02:05:12 Response: - Data of this line
16/03/2009 08:59:57 Request: - Data of this line
16/03/2009 09:00:01 Response: - Data of this line

I don't know which tool to use to compare the date and time.
Thank you in advance for any comments.

Last edited by tanit; 03-16-2009 at 11:12 AM..

tanit

View Public Profile for tanit

Find all posts by tanit

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Working out end time from start + elapsed

Hi, I'm writing a script and have become stuck trying to define a variable (COMP) by adding an elapsed time (ELAPSE e.g 00:55) to a start time (START e.g 23:50). Can anybody give me a solution as to how I can get a completion time in hh:mm from the variables above? thanks Richard

2. Shell Programming and Scripting

Start time/end time and status of crontab job

Is there anyway to get the start time and end time / status of a crontab job which was just completed? Of course, we know the start time of the crontab job since we are scheduling. But I would like to know process start and time recorded somewhere or can be fetched from a command like 'ps'. ...

3. Shell Programming and Scripting

searching between start and end time

Hello All, Below mentioned is my log file. I want to make a script which ask for start time and then end time and then search particular word between those lines. Like start time:2 end time: 4 and then search all values starting from cell 84 between this time. Please Help ...

4. Linux

Process start time not showing correct time

Process start time is not showing the correct time: I had started a process on Jun 17th at 23:30:00. Next day morning when I run the command "ps -ef | grep mq", the process is showing the start date of Jun 17th but the start time is 00:16:41 Day/Date is setup correctly on the server. It...

5. UNIX for Dummies Questions & Answers

script start and end of execution of time

Hi All, Can we get to know the start time and end time of execution of a script? (This script doesn't write any logs.) I mean, is there any built in process logs to track these records?

6. Shell Programming and Scripting

How to calculate time difference between start and end time of a process!

Hello All, I have a problem calculating the time difference between start and end timings...! the timings are given by 24hr format.. Start Date : 08/05/10 12:55 End Date : 08/09/10 06:50 above values are in mm/dd/yy hh:mm format. Now the thing is, 7th(08/07/10) and...

7. UNIX for Dummies Questions & Answers

Setup a cron job and specified the start and end time

Hi guys, How can I specify the start and end time of a cron job. And my start time and end time are specified by minutes. For example, I want to set up a cron runs every 3 minutes from 18:40 to midnight. How can i do this please? Many thanks Best regards, Clu

8. Shell Programming and Scripting

Getting the Start, End time and duration using date command

Oracle Enterprise Linux We want to track how long a process takes to complete its execution. This is what we want in the schell script Before the process is started , get the time with date, hours and minutes execute the process After the process has ended , get the time with date,...

9. Programming

DB2 Query to check table counts,start end time

Dear team I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids . Currently i am using below query but this displays table name and counts for latest run. select name ,CARD from...

LEARN ABOUT DEBIAN

test::data::hash

Hash(3pm)						User Contributed Perl Documentation						 Hash(3pm)

NAME

       Test::Data::Hash -- test functions for hash variables

SYNOPSIS

	       use Test::Data qw(Hash);

DESCRIPTION

       This modules provides a collection of test utilities for hash variables.  Load the module through Test::Data.

   Functions
       exists_ok( KEY, HASH [, NAME] )
	   Ok if the value for KEY in HASH exists.  The function does not create KEY in HASH.

       not_exists_ok( KEY, HASH [, NAME] )
	   Ok if the value for KEY in HASH does not exist.  The function does not create KEY in HASH.

       hash_value_defined_ok( KEY, HASH [, NAME] )
	   Ok if the value for KEY in HASH is defined.	The function does not create KEY in HASH.

       hash_value_undef_ok( KEY, HASH [, NAME] )
	   Ok if the value for KEY in HASH is undefined.  The function does not create KEY in HASH.

       hash_value_true_ok( KEY, HASH [, NAME] )
	   Ok if the value for KEY in HASH is true.  The function does not create KEY in HASH.

       hash_value_false_ok( KEY, HASH [, NAME] )
	   Ok if the value for KEY in HASH is false.  The function does not create KEY in HASH.

SEE ALSO

       Test::Data, Test::Data::Array, Test::Data::Function, Test::Data::Scalar, Test::Builder

SOURCE AVAILABILITY

       This source is in Github:

	       http://github.com/briandfoy/test-data/tree/master

AUTHOR

       brian d foy, "<bdfoy@cpan.org>"

COPYRIGHT AND LICENSE

       Copyright (c) 2002-2009 brian d foy.  All rights reserved.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2009-02-12								 Hash(3pm)