Hi Team,
I have following dataset, which has been attached
Since i using .txt file all the data is in one cell in Alteryx, I would like have only those in between rows which start with REPORT ID: VSS-110 and end with ***END OF VSS-110 REPORT***
As shown in the expected I need only those rows till Last ***END OF VSS-110 REPORT***
I'm looking for dynamic output in which i can remove VSS-120, VSS-130 etc
Input:
| REPORT ID: VSS-110 ABC SERVICE PAGE 1 |
| REPORTING FOR: 100A INT SERVICE PROC DATE: 07FEB1991 |
| ROLLUP TO: 101AH SUMM REPORT REPORT DATE: 06FEB1991 |
| CURR: USR |
| ***END OF VSS-110 REPORT*** |
| REPORT ID: VSS-110 ABC SERVICE PAGE 1 |
| REPORTING FOR: 200A INT SERVICE PROC DATE: 07FEB1991 |
| ROLLUP TO: 201AH SUMM REPORT REPORT DATE: 06FEB1991 |
| CURR: USR |
| CREDIT |
| ***END OF VSS-110 REPORT*** |
| REPORT ID: VSS-110 ABC SERVICE PAGE 1 |
| REPORTING FOR: 200A INT SERVICE PROC DATE: 07FEB1991 |
| ROLLUP TO: 201AH SUMM REPORT REPORT DATE: 06FEB1991 |
| CURR: USR |
| CREDIT |
| COUNT |
| ***END OF VSS-110 REPORT*** |
| REPORT ID: VSS-120 ABC SERVICE PAGE 1 |
| REPORTING FOR: 200A INT SERVICE PROC DATE: 07FEB1991 |
| ROLLUP TO: 201AH SUMM REPORT REPORT DATE: 06FEB1991 |
| CURR: USR |
| CREDIT |
| COUNT |
| ***END OF VSS-120 REPORT*** |
