422,727 Members | 2,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,727 IT Pros & Developers. It's quick & easy.

Extract lines between two pattern appears multiple times in a file

P: 1
I am new to Perl scripting and I have file contains

File: input.log
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.


I have to extract below Output but it is reading all content writing in output file.

Output should be as below:

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
2 Weeks Ago #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.