Visit Our UNIX and Linux User Community


Pick the last one hour lines from log matching this pattern.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Pick the last one hour lines from log matching this pattern.
# 8  
Old 08-12-2013
Thanks chubler
that awk worked.
But It displayed everything in the log file.
Not just 1 hour back.
# 9  
Old 08-12-2013
Can you paste the first line that is displayed here please.
I suspect your datafile doesn't match the posted format particularly check that the year is two digits and not four, ans make sure no additional spaces are in between the dates, eg " 8" for the month.

Last edited by Chubler_XL; 08-12-2013 at 11:19 PM..
# 10  
Old 08-12-2013
the initial lines are the start of the log file. It did not do awk. displayed everything in the file


****************Start Display Current Environment **********
Host OPerating Syatem is linux, version
Java version
# 11  
Old 08-12-2013
OK you have lines that don't match the format at the start of the file.

Try:

Code:
v=$(date --date "-1 hour" +"-vY=%-y -vT=%-m -vD=%-d -vH=%-H -vM=%-M")
awk -F '[[ /:]' $v '
  $4+0>Y ||
  $4+0==Y&&$2+0>T ||
  $4+0==Y&&$2+0==T&&$3+0>D ||
  $4+0==Y&&$2+0==T&&$3+0==D&&$5+0>H ||
  $4+0==Y&&$2+0==T&&$3+0==D&&$5+0==H&&$6+0>M {v=1}
  v' infile

# 12  
Old 08-12-2013
Thanks Chubler,

This avoided the files that do not have timestamp at the start of the file.
But displayed all the lines with the time stamp and also lines in the missdle without timestamp.

And the lines with the timestamp ar enot within an hour.all the lines are picked.
# 13  
Old 08-12-2013
Change last line to /^[[]/&&v' infile to avoid non-date lines following the first match.

I don't know why you are matching dates older than 1 hour, could you post the first line that matches again,
between [code] and [/code] tags so the format isn't lost.
This User Gave Thanks to Chubler_XL For This Post:
# 14  
Old 08-12-2013
Thanks Chubler.
Yes this displayed only the lines with the time stamp.
But not from last hour. All the lines from last 4days are also displayed.
appreciate your help.

Previous Thread | Next Thread
Test Your Knowledge in Computers #157
Difficulty: Easy
The US Department of Defense declared TCP/IP as the standard for all military computer networking in March 1982,
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Grep -v lines starting with pattern 1 and not matching pattern 2

Hi all! Thanks for taking the time to view this! I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern. Example: Drink a soda Eat a banana Eat multiple bananas Drink an apple juice Eat an apple Eat multiple apples I... (8 Replies)
Discussion started by: demmel
8 Replies

2. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

'Hi I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match. Which option is to be used to exclude the line containing the pattern? sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies

3. Shell Programming and Scripting

Pattern from a log within last hour

I want to extract a pattern from a log file within last hour. I am doing grep "pattern" filename | tail -1 It gives the last latest pattern but not within last hour. and if the pattern found in last hour, output success or else failure. (3 Replies)
Discussion started by: santosh2626
3 Replies

4. Shell Programming and Scripting

Pattern matching...of almost same lines

Hi all I am trying to process some data sample input is like this VARIABLE : T axis TDAY TIME : 02-FEB-2004 17:54 19755. VARIABLE : quality flag FILENAME : 1900054_prof.nc Z : 41 ... (3 Replies)
Discussion started by: Akshay Hegde
3 Replies

5. Shell Programming and Scripting

How to pick only the files which are generated in one hour?

Hello Masters, I need one help. I want to copy the files which are continuously generating on one server. But this would be on hourly basis. e.g. -rw-rw-r-- 1 akore akore 0 Feb 12 03:20 test1.log -rw-rw-r-- 1 akore akore 0 Feb 12 03:42 test2.log -rw-rw-r-- 1 akore akore 0 Feb 12 04:22... (2 Replies)
Discussion started by: akore83
2 Replies

6. Shell Programming and Scripting

Finding lines matching the Pattern and their previous lines in a file

Hi, I am trying to locate the occurences of certain pattern like 'Possible network disconnect' in a text file. I can get the actual lines matching the pttern using: grep -w 'Possible network disconnect' file_name. But I am more interested in getting the timing of these events which are... (7 Replies)
Discussion started by: sagarparadkar
7 Replies

7. Shell Programming and Scripting

pattern matching lines using the date, and then joining the lines

Hi Guys, Was trying to attempt the below using awk and sed, have no luck so far, so any help would be appreciated. Current Text File: The first line has got an "\n", and the second line has got spaces/tabs then the word and "\n" TIME SERVER/CLIENT TEXT... (6 Replies)
Discussion started by: eo29
6 Replies

8. Shell Programming and Scripting

counting the lines matching a pattern, in between two pattern, and generate a tab

Hi all, I'm looking for some help. I have a file (very long) that is organized like below: >Cluster 0 0 283nt, >01_FRYJ6ZM12HMXZS... at +/99% 1 279nt, >01_FRYJ6ZM12HN12A... at +/99% 2 281nt, >01_FRYJ6ZM12HM4TS... at +/99% 3 283nt, >01_FRYJ6ZM12HM946... at +/99% 4 279nt,... (4 Replies)
Discussion started by: d.chauliac
4 Replies

9. Shell Programming and Scripting

Pattern Matching and lines after that

I have a huge file and every paragraph has a date. But I want to retrieve the paras for the last two days only. So I can grep and findout the linenum for the first line since yesterday. Now I want to display everything after that line. And I am trying to do this inside a script so the linenum is a... (4 Replies)
Discussion started by: kaushys
4 Replies

10. Shell Programming and Scripting

pattern matching over more lines

hi, i have a text file wich contains following informations: 1 Record 90 in base GUJA_2008 (Created: 2008-01-14 19:00:38, Modified: 2008-01-15 18:54:33) 1 YADM_20080101_A91645666_A91645666 4 2008/01/15/ADM.ADM/20080101.ADM.ADM.A91645666G001.jff 1 Record 91 in base GUJA_2008 (Created:... (3 Replies)
Discussion started by: trek
3 Replies

Featured Tech Videos