Hello nileshjsr and welcome to the monastery.

I can tell you tried to format your question with HTML tags, but like others have said your data is difficult to decipher.

However, I think I can sort of understand what you are asking for.

Usually I would use the flip-flop operator for this kind of thing, but since you don't want the last line of the blocks I just reimplemented a slightly different version.

Let me know if this works for you...

#! /usr/bin/perl

use strict;
use warnings;

my $print;

while (<DATA>) {
    $print = 1 if /^AIR_TCD/;
    $print = 0 if $print && /record\(s\) selected/;

    print if $print;
}

__DATA__
DATE1=2018-05-24
DATE=2018-05-20
SETTING USER RELATED INFORMATION ..
SETTING USER RELATED INFORMATION ..

 ; Database Connection Information

 ;Database server    = DB2/LINUXX8664 10.5.6
 ;SQL authorization ID  = ORV5_ETL
 ;Local database alias  = CHADDB

AIR_TCD_AIR_CS5
-------------------------------------------

1          2      3     
------------------- ----------- -----------
2018-05-20-00.00.00     761   1186102
2018-05-21-00.00.00     773   1226970
2018-05-22-00.00.00     746   1158361
2018-05-23-00.00.00     767   1225759
2018-05-24-00.00.00     727   1123991

 ; 5 record(s) selected.

DB20000I The TERMINATE command completed successfully.
SETTING USER RELATED INFORMATION ..

 ; Database Connection Information

 ;Database server    = DB2/LINUXX8664 10.5.6
 ;SQL authorization ID  = ORV5_ETL
 ;Local database alias  = CHADDB

AIR_TCD_CCN:VOICE_CS5
-------------------------------------------

1          2      3     
------------------- ----------- -----------
2018-05-20-00.00.00    4554   7578729
2018-05-21-00.00.00    4533   7533879
2018-05-22-00.00.00    4399   7349718
2018-05-23-00.00.00    4597   7781008
2018-05-24-00.00.00    4411   7344806

 ; 5 record(s) selected.
[download]

Output:

AIR_TCD_AIR_CS5
-------------------------------------------

1          2      3     
------------------- ----------- -----------
2018-05-20-00.00.00     761   1186102
2018-05-21-00.00.00     773   1226970
2018-05-22-00.00.00     746   1158361
2018-05-23-00.00.00     767   1225759
2018-05-24-00.00.00     727   1123991

AIR_TCD_CCN:VOICE_CS5
-------------------------------------------

1          2      3     
------------------- ----------- -----------
2018-05-20-00.00.00    4554   7578729
2018-05-21-00.00.00    4533   7533879
2018-05-22-00.00.00    4399   7349718
2018-05-23-00.00.00    4597   7781008
2018-05-24-00.00.00    4411   7344806
[download]

Best,

Jim

Thanks Jim. It has been worked currently

nileshjsr: Your problem is not that you're not using code tags, but rather that you're using too many of them! Your posts now look like

<code>File: input.log</code> <code>DATE1=2018-05-24</code> <code>DATE=
+2018-05-20</code> <code>SETTING USER RELATED INFORMATION ..</code>
[download]

<code>
File: input.log
DATE1=2018-05-24
DATE=2018-05-20
SETTING USER RELATED INFORMATION ..
with each line of data
represented by a line
in this block
</code>
[download]

Also, please do add some question to your post. Also, please do not post yet another node with fixed content; instead, please go back and edit/fix your original post; please see How do I change/delete my post? for details.

Welcome to the monastery, nileshjsr. It will help your cause no end if you could edit your post and put the contents of the file within <code> ... </code> tags. That way we can clearly see and download the data.

While you are editing the post you could also add your question. Thanks.