Sponsored Content
Top Forums Shell Programming and Scripting Filtering the yesterdays date from log files via script. Post 302388605 by linuxgeek on Thursday 21st of January 2010 01:52:15 AM
Old 01-21-2010
Filtering the yesterdays date from log files via script.

hi All,

I have this sample text file - access.log:

Jan 18 21:34:29 root 209.151.232.70
Jan 18 21:34:40 root 209.151.232.70
Jan 18 21:34:43 root 209.151.232.70
Jan 18 21:34:56 root 209.151.232.70
Jan 18 21:35:10 root 209.151.232.70
Jan 18 21:35:23 root 209.151.232.70
Jan 18 21:36:04 root 209.151.232.70
Jan 18 21:36:57 root 209.151.232.70
Jan 18 21:37:07 root 209.151.232.70
Jan 19 03:57:54 root 61.76.46.135
Jan 19 03:57:57 root 61.76.46.135
Jan 19 03:58:00 root 61.76.46.135
Jan 19 03:58:05 root 61.76.46.135
Jan 19 03:58:08 root 61.76.46.135
Jan 19 03:58:11 joy 61.71.46.13
Jan 19 04:15:16 joy 61.71.46.13
Jan 19 04:15:19 joy 61.71.46.13
Jan 20 04:46:58 vcp 213.248.55.159
Jan 20 04:47:27 vcp 213.248.55.159
Jan 20 04:47:43 vcp 213.248.55.159
Jan 20 04:47:57 vcp 213.248.55.159
Jan 20 04:48:27 vcp 213.248.55.159
Jan 20 04:48:57 vcp 213.248.55.159
Jan 20 04:49:27 vcp 213.248.55.159
Jan 20 04:49:56 vcp 213.248.55.159

can you give me the script to filter the records only for yesterdays date ?

Appreciate much your help.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

yesterdays files

I am new to UNIX and I am trying to write a shell script. I want to be able to list all files that were created with yesterdays dates (APR 29 as an example) that are not 0 file size.Then in those files I want to look for the string 'Process Complete' and list all files that DONT have that string.... (8 Replies)
Discussion started by: tonydsam
8 Replies

2. UNIX for Dummies Questions & Answers

Get yesterdays date given todays date

Hi Guys. I am very new to UNIX. I need to get yesterdays and tommorows date given todays date. Which command and syntax do i use in basic UNIX shell. Thanks. (2 Replies)
Discussion started by: magikminox
2 Replies

3. Shell Programming and Scripting

Korn Shell Script - Getting yesterdays date

I need to get yesterdays date in the format yyyymmdd I can get today's date simply enough - 20031112 Is there any way to substract 1 from this easily enough in korn shell script? It has to be korn shell and not perl (20 Replies)
Discussion started by: frustrated1
20 Replies

4. Shell Programming and Scripting

yesterdays date

To get yesterays date, execute the command : TZ=aaa24 date +%Y%m%d Output format will be yyyymmdd (2 Replies)
Discussion started by: sujju1985
2 Replies

5. Shell Programming and Scripting

Script to copy log files with today's date

I am a newbie to scripting. I need a korn shell script to copy log files of current day to archive folder and rename with current days date stamp. I would really appreciate your help. File structure is as follows. Everyday files get overwritten, so I need copy to a archive directory and... (3 Replies)
Discussion started by: mdncan
3 Replies

6. UNIX for Dummies Questions & Answers

How to get yesterdays julian date

Hi, Was using date +%Y%j to get current julian date. Can anyone let me know how can I get y'day's julin date. Thx Did check FAQ but couldn't find anything. Thanks. (3 Replies)
Discussion started by: er_ashu
3 Replies

7. UNIX for Dummies Questions & Answers

Need to pull Yesterdays Date...

I tried this and it works for the most part, but if the date is 20090301, it displays 20090300. YESTERDAY=$((`date +%Y%m%d` -1)) (2 Replies)
Discussion started by: cards0622
2 Replies

8. Shell Programming and Scripting

how to get the yesterdays date?

Hi All, Can anybody help me to get the yesterdays date in perl script. My script is as below #!/bin/perl -w $yes=system("TZ=IST+24 date +%d-%m-%Y"); print "$yes\n"; script is writting the date but with 0 pls see the output below #!/bin/perl -w $yes=system("TZ=IST+24 date... (2 Replies)
Discussion started by: jam_prasanna
2 Replies

9. Shell Programming and Scripting

Delete log files content older than 30 days and append the lastest date log file date

To delete log files content older than 30 days and append the lastest date log file date in the respective logs I want to write a shell script that deletes all log files content older than 30 days and append the lastest log file date in the respective logs This is my script cd... (2 Replies)
Discussion started by: sreekumarhari
2 Replies

10. Shell Programming and Scripting

Get yesterdays Date for Input Date

Hi, I have been trying to get the yesterdays date for the Input date I pass. I know how to do for the current timestamp but how to do for the input date. Is there any way I can convert to epoch time and do manipulations and back to human readable date? Please help Thanks ... (1 Reply)
Discussion started by: abhi1988sri
1 Replies
function::ctime

FUNCTION:(3stap)					      Time utility functions						  FUNCTION:(3stap)

NAME
function::ctime - Convert seconds since epoch into human readable date/time string SYNOPSIS
ctime:string(epochsecs:long) ARGUMENTS
epochsecs Number of seconds since epoch (as returned by gettimeofday_s) DESCRIPTION
Takes an argument of seconds since the epoch as returned by gettimeofday_s. Returns a string of the form "Wed Jun 30 21:49:08 1993" The string will always be exactly 24 characters. If the time would be unreasonable far in the past (before what can be represented with a 32 bit offset in seconds from the epoch) the returned string will be "a long, long time ago...". If the time would be unreasonable far in the future the returned string will be "far far in the future..." (both these strings are also 24 characters wide). Note that the epoch (zero) corresponds to "Thu Jan 1 00:00:00 1970" The earliest full date given by ctime, corresponding to epochsecs -2147483648 is "Fri Dec 13 20:45:52 1901". The latest full date given by ctime, corresponding to epochsecs 2147483647 is "Tue Jan 19 03:14:07 2038". The abbreviations for the days of the week are 'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', and 'Sat'. The abbreviations for the months are 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', and 'Dec'. Note that the real C library ctime function puts a newline (' ') character at the end of the string that this function does not. Also note that since the kernel has no concept of timezones, the returned time is always in GMT. SystemTap Tapset Reference May 2013 FUNCTION:(3stap)
All times are GMT -4. The time now is 10:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy