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

[flying008]

Hi, @BRRLL99 

FYI.

((?:SRE.*?SRE\s)(\d+))?(?:\s.*?F\s?TD\s)([\d\s,]+)

[BRRLL99]

In some cases the After SRE digits are not getting picked

I need All the 10 digits after second SRE and Date FTD

For Example: 

SRE 10116        //NPS19034IA6WUTTF 1/RBC INTERNATIONAL SERVICE ASSOCI 1/RBC INTERNATIONAL SER SSN4791432 / ABI: SETTLEMENT OF BBI:SRE 1009124714 S01 - FTD 02-06 -2024/INST/RBC INTER NATION OL SERVICE 

should be picked 1009124714, 02-06 -2024

[flying008 · Accepted solution]

Hi, @BRRLL99 

You can parse by (\d+)

******

If can help you get your want, please mark it as a solution and give a like for more share.

[BRRLL99]

I have updated the reply

do to some reasons SRE and dates are not picking correctly

[flying008]

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

[BRRLL99]

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

I have applied this formula it is only giving dates, Remaining columns showing blank
I have 16,000 records, with different combinations
I want to pick Second SRE digits

[flying008]

The above animation is the result of your sample data, if you get a blank, either the data provided is not the same as your real data structure, and more data or a more accurate logical description may be needed.

[BRRLL99]

My original data is very Unorganized

can you give me regex expression, when ever there is SRE and 10 digits followed by, 

only those digits needs to be picked

[flying008]

(?:SRE\s?)(\d{10})