File Scan

Shell Programming and Scripting
1

Hi everyone , i m working on Sun solaris and i have a file "smsapp.cur" which has information like this paragraph given below , there are millions of such paragraphs

From:923212802736
To:923222326807
logMessage: 07-04-08 17:34:29 Getting message topup from code page default in language English using encoding UTF-8
logMessage: /----------------------------------------
logMessage: |RESPONSE: (139)
logMessage: |----------------------------------------
logMessage: |0000: 44 65 61 72 20 63 75 73 74 6f 6d 65 72 2c 20 61 Dear customer, a
logMessage: |0016: 63 63 6f 75 6e 74 20 39 32 33 32 32 32 33 32 36 ccount 923222326
logMessage: |0032: 38 30 37 20 68 61 73 20 62 65 65 6e 20 73 75 63 807 has been suc
logMessage: |0048: 63 65 73 73 66 75 6c 6c 79 20 74 6f 70 70 65 64 cessfully topped
logMessage: |0064: 20 75 70 20 77 69 74 68 20 52 73 20 37 30 2e 30 up with Rs 70.0
logMessage: |0080: 30 2c 20 79 6f 75 72 20 6e 65 77 20 61 63 63 6f 0, your new acco
logMessage: |0096: 75 6e 74 20 62 61 6c 61 6e 63 65 20 69 73 20 52 unt balance is R
logMessage: |0112: 73 20 36 39 35 2e 38 33 2e 20 52 45 46 49 44 3a s 695.83. REFID:
logMessage: |0128: 20 32 32 38 31 33 39 37 38 34 2e 228139784.
logMessage: \----------------------------------------
logMessage: 07-04-08 17:34:29 Sending message to 923212802736
STKApp:run()::Sun Apr 08 17:34:29 PKT 2007::INBOX MESSAGES Length:1
logMessage: 07-04-08 17:34:29 Using product: P2P topup SKU:72
logMessage: 07-04-08 17:34:29 STKRequestProcessor:run()::Entered before calling processMessage()
logMessage: 07-04-08 17:34:29 SMSRequestProcessor: From: 923214330174, Message: B 03224906929 20
logMessage: type=B
msisdn=03224906929
amount=20

Amount:Rs 20.00

Now what i want is that somehow i only get responce code line ( which i have set as italic ) between certain time stamps like since yesterdays 04:00 pm till todays 03:00 AM

i have tried something like this

function while_read_LINE
{
cat $FILENAME | while read LINE
do
find "RESPONCE" $LINE > responce.txt
:
done
}

but i donno how to cater time stamp

Regards and Thanks

2

First you have to convert time stamps into seconds and then deffirentiate them...

you can find it this forum....

thanks

3 
nawk '/[0-9][0-9]-/ {
  dt = ($2" "$3) ; next }
    /RESPONSE/ { gsub(/[()]/ ,"" , $3 )
      if ( ( dt >= from ) && ( dt <= to ) )
        print dt, "Response Code:", $3 
}' from="07-04-07 16:00:00" to="07-04-08 03:00:00" inputfile