In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex

BRRLL99
11 - Bolide

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
  
90006489323/15/2024
  
 3/22/2024
10004367833/15/2024
11 REPLIES 11
BRRLL99
11 - Bolide

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
15 - Aurora
(?:F\s?TD\s)([\d\s\-,]+)
Labels
Top Solution Authors