note
Samy_rio
<p>Hi [flemi_p], this will help you if I understood your question correctly.</p>
<code>
use strict;
use warnings;
open(IN, 'E:\test\infile.txt') || die $!;
my @infile = <IN>;
close(IN);
open(RE, 'E:\test\require.txt') || die $!;
my @reqids = <RE>;
close(RE);
chomp @infile;
chomp @reqids;
for my $index (0..$#infile){
for my $rindex (0..$#reqids){
if ($infile[$index] =~ m/$reqids[$rindex]/){
if ($infile[$index] =~ m/select/i){
my $count = $index;
$count += 3;
print "$infile[$_]\n" for ($index..$count);
}
}
}
}
__END__
Output as:
----------
15:53:43.908 Dbg 10739 Oracle: id='12.1' req='834531' SQL: SELECT crf_routing.CRF_RT_ACD1_QUEUE,crf_routing.CRF_RT_ACD1_SIZE,crf_ro'
+0551 Executed SQL statement 'SELECT', start retrieve records...
+0826 MSG_RETRIEVED2 status='DBM_SUCCESS'
+0826 MSG_RETRIEVED status='DBM_NOMORE'
</code>
<p><i>Updated</i> Thanks [davorg].</p>
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-460657">
<p>Regards,<br>Velusamy R.<hr><c>eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';</c></p>
</div></div>
593887
593887