Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How can I get entries between two points

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How can I get entries between two points
# 1  
Old 08-07-2008
How can I get entries between two points
Hi,

I am trying to write a script to get entries between two points lets say start and end points from a log file,

the log file time format is as follows

Start - 07/Aug/2008:18:26:43
End - 07/Aug/2008:19:36:43

I tried using the following awk command but it couldnt pick up the entries in between

awk /'06\/Aug\/2008:18:26:43/,/06\/Aug\/2008:18:36:43/' request.log

Thanks
# 2  
Old 08-07-2008
use sed :

sed -n '/06\/Aug\/2008:18:26:43/,/06\/Aug\/2008:18:36:43/ p' request.log
# 3  
Old 08-07-2008
or without sed, but 6 lines instead of one:

#! /usr/bin/ksh
#
#
#
#
TOT_LENGTH=`wc -l request.log | awk '{print $1}' | tr -d " "`
START_LINE=`grep -n "Start - 07/Aug/2008:18:26:43" request.log | cut -f1 -d:`
STOP_LINE=`grep -n "End - 07/Aug/2008:19:36:43" request.log | cut -f1 -d:`
LAST_PART=`expr $TOT_LENGTH - $START_LINE`
DIFF_START_END=`expr $STOP_LINE - $START_LINE`
tail -$LAST_PART request.log | head -$DIFF_START_END
###
# 4  
Old 08-07-2008
Error
Hi,
Thanks for your replies, actually I tried both the methods but it doesnt seem to pick up the log entries between the start and end times, The above code

Quote:
Originally Posted by MikaBaghinen
or without sed, but 6 lines instead of one:

#! /usr/bin/ksh
#
#
#
#
TOT_LENGTH=`wc -l request.log | awk '{print $1}' | tr -d " "`
START_LINE=`grep -n "Start - 07/Aug/2008:18:26:43" request.log | cut -f1 -d:`
STOP_LINE=`grep -n "End - 07/Aug/2008:19:36:43" request.log | cut -f1 -d:`
LAST_PART=`expr $TOT_LENGTH - $START_LINE`
DIFF_START_END=`expr $STOP_LINE - $START_LINE`
tail -$LAST_PART request.log | head -$DIFF_START_END
###
Gives a syntax error

I tried using the following methods also but without any result

1. awk /'06\/Aug\/2008:18:26:43/,/06\/Aug\/2008:18:36:43/' request.log

2. sed -n -e '/06\/Aug\/2008:18:26:43/,/06\/Aug\/2008:18:36:43/' -e '/06\/Aug\/2008:18:36:43/q' request.log

3. awk '/06\/Aug\/2008:18:26:43/&&f{exit}f;/06\/Aug\/2008:18:36:43/{f++}' request.log

A sample log entry is as follows

198.232.219.21 - ukla_portal_23@ukla.com [07/Aug/2008:14:51:23 -0400] "GET HTTPS://modulemgr.stage.ukla.com/mys...e_services.gif HTTP/1.1" 200 148
198.232.219.21 - ukla_portal_23@ukla.com [07/Aug/2008:14:55:23 -0400] "GET HTTPS://modulemgr.stage.ukla.com/mys...vice_green.gif HTTP/1.1" 200 3168
198.232.219.21 - ukla_portal_23@ukla.com [07/Aug/2008:15:05:23 -0400] "GET HTTPS://modulemgr.stage.ukla.com/mys.../gray_line.gif HTTP/1.1" 200 371

The above is just a sample and there are close to 10000 lines in a log file in an hour.

Please help me in finding the entries between two points (Start - End )

Your help is greatly appreciated !

Thanks
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help with decimal points

Hi All, I would like to set decimal point to 16 in the following bash script but it has syntax error at }: awk '{printf"%.16e", (a<500,a++,$1/(a*1.1212121212121229e-02))}' input.dat >output.datHow may I set it in the correct way please? Thank you very much! (6 Replies)
Discussion started by: sxiong
6 Replies

2. Shell Programming and Scripting

Returns points of an ellipse

Hi, Dose any one know, How can i return a 3D ellipse points if i have these information about the ellipse? All 3 length of axes, dip of each plane and azimuth of each axes. i.e., axes length=(1 cm, 2 cm, 3cm);dip of planes=(15 deg, 80 deg);azimuth of each axes=(10 deg,50 deg, 120 deg). I... (3 Replies)
Discussion started by: saeed.soltani
3 Replies

3. UNIX for Dummies Questions & Answers

Finding data value that contains x% of points

Hi, I need help on finding the value of my data that encompasses certain percentage of my total data points (n). Attached is an example of my data, n=30. What I want to do is for instance is find the minimum threshold that still encompasses 60% (n=18), 70% (n=21) and 80% (n=24). manually to... (4 Replies)
Discussion started by: ida1215
4 Replies

4. Red Hat

Mount Points? How?

Hi folks, I have been asked to performed the following: Add the following new moint points systemA:/avp and SystemB:/usr/sap/trans to be the new linux server ZZZ How can I add those mount points and how those mount points can become another linuz server?:wall::wall::wall: (2 Replies)
Discussion started by: 300zxmuro
2 Replies

5. Shell Programming and Scripting

Aggregated points

Combine points of specific key (a1) based on user defined size (lets say 200 in this example). so a1 191 and 191+200 and sum of all the values (4th column) and vice versa... Thanx a bunch! a1 191 201 1 a1 201 211 2 a1 211 221 1 a1 ....... .... a2......... ........ (7 Replies)
Discussion started by: quincyjones
7 Replies

6. Post Here to Contact Site Administrators and Moderators

Points?

Has any thought been given to assigning points to threads much in the way the HP ITRC forums do? This might not be possible, just a thought. (1 Reply)
Discussion started by: candlejack
1 Replies

7. UNIX for Advanced & Expert Users

mount points

hi, I believe a mount point does not have to be a physical disk, but rather a logical one? Is this correct? if so, how can I find out if my mount points are on different physical disks? thanks (9 Replies)
Discussion started by: JamesByars
9 Replies

8. UNIX and Linux Applications

Gnuplot question: how to plot 3D points as colored points in map view?

I have a simple gnuplot question. I have a set of points (list of x,y,z values; irregularly spaced, i.e. no grid) that I want to plot. I want the plot to look like this: - points in map view (no 3D view) - color of each point should depend on its z-value. - I want to define my own color scale -... (0 Replies)
Discussion started by: karman
0 Replies

9. UNIX for Dummies Questions & Answers

Mount Points at reboot

How do I make a mount point reconnect at boot without editing /etc/fstab? Is there an option (or switch) to make this persistent when issuing the mount command from a client? (1 Reply)
Discussion started by: AIXdumb455
1 Replies

10. UNIX for Advanced & Expert Users

mount points

sometimes in Solaris 8 when I go to mount filesystems using either the mount command or by editing the /etc/vfstab, i get a nice little error message saying the the number of allowable mount points has been exceeded. I have read man pages until I am blue in the face and no where can I find what the... (3 Replies)
Discussion started by: manderson19
3 Replies
Login or Register to Ask a Question