Shell Programming and Scripting

Hello,
I need help about a shell script
I have a text file with this fields:

2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:40: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:48: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:58: --> ---ORA-28817: PL/SQL function returned an error.

I know the second field.

Ec. Giving the interval:
09:33:40 and
09:33:58
how I take only the rows between this interval ?


I'm trying with sed and grep but nothing....

Thanks for the help

With awk:

Code:

awk '/09:33:40/{f=1;next}/09:33:58/{exit}f' file

Regards

Code:

$ nawk '{gsub(/:/,"",st);gsub(/:/,"",et);gsub(/:/,"",$2);if($2>=st && $2<=et) print }' st=09:33:40 et=09:33:58 infile
2009/01/19 093340 --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 093348 --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 093358 --> ---ORA-28817: PL/SQL function returned an error.
$

#!/bin/ksh
. ./was.env
dt=$(date +"%m"-"%d"-"%Y"-"%H":"%S")
while :
do
#a=`cat $log_dir/$app_name.pid | cut -d "" -f1 `
if [ -f $log_dir/$app_name.pid ]
then
break
else
echo "~~~~~~~~~~~~~~~~~~~PID Not Found~~~~~~~~~~~~~~~~~~~~~~~~" >>$report_dir/$app_name.$dt.log
tail -100 $log_dir/SystemOut.log >> $report_dir/$app_name.$dt.log
break
fi
done
===========================================

cat was.env
app_name=sys
log_dir=/home/justus/scripts/log
report_dir=/home/justus/scripts/report

flag=0
while read line
do

part=`echo $line | cut -d " " -f2`

if [ $part = "09:33:58:" ]
then
flag=0
fi

if [ $flag -eq 1 ]
then
echo $line
fi
if [ $part = "09:33:40:" ]
then
flag=1
fi
done < ./test_file






cat ./test_file

2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:40: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:48: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:58: --> ---ORA-28817: PL/SQL function returned an error.



./extract_line.sh
2009/01/19 09:33:48: --> ---ORA-28817: PL/SQL function returned an error.