I have following dataset in
1. whenever is 2nd SRE in the dataset it should extracted into separate column
2. F TD followed by date should be extracted into separate column
| Data |
| NONREF //ABC123456H75LS3K NONREF |
| SRE 12104 //NZS19934AQZRTF 1/VISA INTERNATIONAL SERVICE ASSOCI 1/VISA INTERNATIONAL SER ORN123897 / SRE 9000648932 S01 , F TD 03,1 5,2024/INST/RBC INTER NATION OL SERVICE |
| NONREF //NONREF SIM TRANSACTION FEES 01FEB24 TO 29FEB24 |
| TT ABM731885AZK //AXS12034GX6L7X6O SAM RABCCC RRIA ZURRAY IUDY RRIA DU COMMISSION NZD, F TD 03, 2 2, 2024 |
| SRE 10116 //NPS19034IA6WUTTF 1/RBC INTERNATIONAL SERVICE ASSOCI 1/RBC INTERNATIONAL SER SSN4791432 / SRE 1000436783 S01 , F TD 03,1 5,2024/INST/RBC INTER NATION OL SERVICE |
Expected Output: Parse out into separate column
| Expected Output |
| | |
| 9000648932 | 3/15/2024 |
| | |
| | 3/22/2024 |
| 1000436783 | 3/15/2024 |
