Regex

[BRRLL99]

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

[BRRLL99]

can give regex for date also  mm/dd/yy

F TD 02,02,2024

FTD 01/02/2024

F TD 11/12/2024

Whenever FTD contains following date needs be picked which ever format it is

[flying008 · Accepted solution]

(?:F\s?TD\s)([\d\s\-,]+)