I have another solution for you: for each line, you extract date and time et put it in format (order and fix number of digits are important): yy/mm/dd:hh:mm:ss You put your begin and end date in the same format
Then, use a string comparaison function to determine if the extracted_and_reformated_date is between begin and end DP "gab.seun jones.ewulomi" a écrit : > Hi people, > > I have a huge ascii text file with data collection point. the text file is > of the form(below) > > How could I use grep/awk to grep for data between a time frame > > In Kbits R1 6/1.10 3/105 to R2 31/10/03 10:15:00 3657.07 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 10:20:00 3976.85 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 10:25:00 5088.18 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 11:00:00 3471.26 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 11:05:00 4311.4 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 11:10:00 2000.9 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 12:50:00 3021.64 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 12:55:00 3385.86 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 13:00:00 3483.98 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 13:05:00 3920.98 > In Kbits FR1 6/1.10 3/105 to R2 31/10/03 14:00:00 5627.66 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 14:05:00 5252.07 > In Kbits R1 6/1.10 3/105 to R2 31/10/03 14:10:00 3768.24 > > I can use awk and grep to get required columns and to get data for a set > date but I dont know how to grep for data for between time frames in a day. > > >From the week data to get all data for a certain date i usually use > > $ grep '^03/.*/2003' <data file> > > BUT If I would like to see all data within a week between 10am and 14pm how > can I do this? > > Can someone please help as I think have tried everything to my knowledge and > understanding > > Any help will be greatly appreciated > > regards, > gab > > _________________________________________________________________ > Find a cheaper internet access deal - choose one to suit you. > http://www.msn.co.uk/internetaccess > > -- > Unsubscribe mailto:[EMAIL PROTECTED] > Help mailto:[EMAIL PROTECTED] > Archive http://www.ee.ethz.ch/~slist/rrd-users > WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi -- Attached file removed by Ecartis and put at URL below -- -- Type: text/plain -- Size: 1k (1255 bytes) -- URL : http://www.ee.ethz.ch/~slist/p/08-Disclaimer.txt -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
