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 |
Solved! Go to Solution.
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
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.
I have updated the reply
do to some reasons SRE and dates are not picking correctly
((?:SRE.*?SRE\s)(\d+))?(?:\s.*?F\s?TD\s)([\d\s\-,]+)
((?: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
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.
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
(?:SRE\s?)(\d{10})