grep - date & time range


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
grep - date & time range

Hi,

I need to search email files by date & time range in email files.
The timezone is not important.

Can someone plz advise how i can do this ?

For e.g A user can specify only
[1] A single date
[2] A date range
[3] date & time range

Below is part of the email file.


Quote:
Received: from smtp.eds.mu (localhost [127.0.0.1])
by smtp.eds.mu (Postfix) with ESMTPA id 4E8B49683A7
for <xxxx@xxxx>; Mon, 8 Feb 2010 10:41:28 +0400 (MUT)
MIME-Version: 1.0
Date: Mon, 08 Feb 2010 10:41:28 +0400
From: xxxxxx <xxx.xxx@xxx.mu>
To: xxxxx <xxx@xxx.mu>
Subject: Some Subject
# 2  
Basically you need to convert the date to Julian Days for a date range or convert date/time to epoch seconds. You can do everything with epoch seconds, even though it is a tad longer. I use seconds.

Do you have perl or do you need a C example? You can do Julian Day arithmetic in shell, but that doesn't solve the date/time issue.
# 3  
Quote:
Originally Posted by jim mcnamara
Basically you need to convert the date to Julian Days for a date range or convert date/time to epoch seconds. You can do everything with epoch seconds, even though it is a tad longer. I use seconds.

Do you have perl or do you need a C example? You can do Julian Day arithmetic in shell, but that doesn't solve the date/time issue.
Please provide a perl example
# 4  
can we use awk/sed to achieve this ??
Smilie

---------- Post updated at 05:43 PM ---------- Previous update was at 03:52 PM ----------

Quote:
Originally Posted by jim mcnamara
Basically you need to convert the date to Julian Days for a date range or convert date/time to epoch seconds. You can do everything with epoch seconds, even though it is a tad longer. I use seconds.

Do you have perl or do you need a C example? You can do Julian Day arithmetic in shell, but that doesn't solve the date/time issue.
Will the following pseudocode work ?

Quote:
start_epoch <= epoch(start date&time)
end_epoch <= epoch(end date&time)

mytimestamp <= get timestamp in file
mytimestamp_epoch <= epoch(mytimestamp)

if (mytimestamp_epoch >=start_epoch && mytimestamp_epoch <=end_epoch)
then
keep the file
end if
# 5  
Quote:
Originally Posted by jim mcnamara
Basically you need to convert the date to Julian Days for a date range or convert date/time to epoch seconds. You can do everything with epoch seconds, even though it is a tad longer. I use seconds.

Do you have perl or do you need a C example? You can do Julian Day arithmetic in shell, but that doesn't solve the date/time issue.
Yes, It works.
Thanks a lot. Smilie
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #963
Difficulty: Medium
Conficker, also known as Downup, Downadup and Kido, was a computer worm targeting the Microsoft Windows operating system that was first detected in November 2008.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep in a log file within a time range (hour)

Hi, im trying to write a grep script that returns me the last inputs added in the last hour in the log file. Literally i have nothing yet but: grep 'Line im looking for' LOGFILE.log | tail -1 this only gives me the last input, but no necessarily from the last hour. Help Please. (4 Replies)
Discussion started by: blacksteel1988
4 Replies

2. Shell Programming and Scripting

run script in time and date range

i need to run one script inside of other, and there is some terms - main script in scheduled in cron for everyday runing every 5min - i need to run /tmp/script2.sh after first 3 days in month - i need to run /tmp/script2.sh from 7-9AM, main script is runining all day all recommendations are... (1 Reply)
Discussion started by: waso
1 Replies

3. UNIX Desktop Questions & Answers

grep a range of time & date

how can i grep a range? i have a text file with the following text: result.log.00:2012/01/02 12:00:07.422 LOG STARTED HERE N6Kashya29MemoryShieldScheduler_AO_IMPLE, pid=8662/8658, config=(alertThreshold=10,alertLevel=0,killThreshold=7200,coreThreshold=0,full=1), deltaTime=0,... (1 Reply)
Discussion started by: boaz733
1 Replies

4. Shell Programming and Scripting

How to put date range from a perl & sql script

Hi Guys, Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below.. #!/usr/bin/perl use strict; use Env qw(ORACLE_HOME); my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S... (1 Reply)
Discussion started by: pinpe
1 Replies

5. Programming

DATE & TIme

Can we select the datetime from oracle database in “hhmmssnnnccyymmdd” format ? please help to solve this..... (2 Replies)
Discussion started by: Sanal
2 Replies

6. Shell Programming and Scripting

Date and time range extraction via Awk or analysis script?

Hello does anyone know of an awk that will extract log file entries between a specific date and time range, eg: awk '/15\/Dec\/2010:16:10:00/, /15\/Dec\/2010:16:15:00/' access_log but one that works? Or a free command line log file analysis tool/script? I'd like to be able to view... (2 Replies)
Discussion started by: competitions
2 Replies

7. Shell Programming and Scripting

Grep by range of date from file creation in directory

Hi Expert, Need your scripting and finding data so that it help me to find the culprit of this memory usage error. Data provided here is a sample. Process Snapshot directory: /var/spool/processes-snapshot webdev9o9% pwd /var/spool/processes-snapshot webdev9o9% ls -lrct -rw-r--r-- ... (3 Replies)
Discussion started by: regmaster
3 Replies

8. Shell Programming and Scripting

About date & time difference

Hello All, I was having a look on threads on the Forum about time calculation but didn't find exactly this issue. For instance, if we have these 2 dates, begin & end : 20100430235830 20100501000200 Is there anyway, awk, ksh, perl to calculate the difference in sec and get for... (6 Replies)
Discussion started by: rany1
6 Replies

9. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

10. UNIX for Dummies Questions & Answers

Time & Date Command

Hey all, When you run the 'ls -la' command it'll show you the time and dates of all files/directories. Now what I am trying to do is create a script that will tell me what files haven't been used in over the past 1 month and what the time and date is that the files that haven't been accessed in... (2 Replies)
Discussion started by: merlin
2 Replies

Featured Tech Videos