Regex

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

Data Investigation

Accepted answers

flying008

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.

flying008

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

All comments

flying008

Hi, @BRRLL99

FYI.

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

录制_2024_03_28_13_59_15_685.gif

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

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\-,]+)

录制_2024_03_28_15_21_37_455.gif

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.