The script provided by bipinajith works well. But there could be many date above each request type in which i need to pick the date immediately before the Request type string. i have highlighted the dates in bold. we cannot seach with date and time since it will be changed month on month. Could you please suggest me to get this date?.
HTML Code:
Cat test
Nov 10, 2012 5:12:53 AM
Nov 10, 2012 5:13:53 AM
[B]Nov 10, 2012 5:17:53 AM[/B]
INFO: Request Type
Line 1. <fullOperation>MAKE:NUMBER:9366109380:PPAY2;</fullOperation>
Line 2. <starttime>20081003000047</starttime>
Line 3. <stoptime>20081003000047</stoptime>
Line 4. <fullResult>940120105;;</fullResult>
Line 5. <status>FAILED</status>
Nov 10, 2012 5:18:53 AM
Nov 10, 2012 5:19:53 AM
[B]Nov 10, 2012 5:20:53 AM[/B]
WARNING: Request Method
Line 1. <fullOperation>MAKE:NUMBER:5424683284:PPAY2;</fullOperation>
Line 2. <starttime>20081003000047</starttime>
Line 3. <stoptime>20081003000047</stoptime>
Line 4. <fullResult>940120105;;</fullResult>
Line 5. <status>FAILED</status>
Nov 10, 2012 5:22:53 AM
Nov 10, 2012 5:23:53 AM
[B]Nov 10, 2012 5:25:53 AM[/B]
FATAL: Response Type
Line 1. <fullOperation>MAKE:NUMBER:5424678435:PPAY2;</fullOperation>
Line 2. <starttime>20081003000047</starttime>
Line 3. <stoptime>20081003000047</stoptime>
Line 4. <fullResult>940120105;;</fullResult>
Line 5. <status>FAILED</status>
Result
---------
Nov 10, 2012 5:17:53 AM,INFO,Request Type,MAKE:NUMBER:9366109380:PPAY2;,20081003000047,20081003000047,940120105;;,FAILED
Nov 10, 2012 5:20:53 AM,WARNING,Request Method,MAKE:NUMBER:5424683284:PPAY2;,20081003000047,20081003000047,940120105;;,FAILED
Nov 10, 2012 5:25:53 AM,FATAL,Response Type,MAKE:NUMBER:5424678435:PPAY2;,20081003000047,20081003000047,940120105;;,FAILED