Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Regex

BRRLL99
11 - Bolide

Hi Team,

 

/tenants/ct/108251/prod/rec/processing/olympic/olybl_ion_2022050045525_20220505_20221545848445.txt
/tenants/ct/108251/prod/rec/processing/olympic/APR_TLM_FXCASH_2022_05_15_SYS_Fwd_20221545663348.csv
/tenants/ct/108251/prod/rec/processing/apac/GLASS_APAC_CDGL_DAILY_20220415_2026556411478_EXEMPTION_20224547788955.txt
/tenants/ct/108251/prod/rec/processing/apac/GLASS_APAC_CDGL4_2022_03_03_20221545445568.csv
/tenants/ct/108251/prod/rec/processing/idda/t240287bl_1298672_20220803_202284775654.txt
/tenants/ct/108251/prod/rec/processing/idda/OPICS10390_BAL_KOR_20220407101255_20224545565677.txt
/tenants/ct/108251/prod/rec/processing/sap_fv/s4_idn_sap_abcd_tcs_future_20221015_20224545888886.csv
/tenants/ct/108251/prod/rec/processing/sap_fxrates/frontier_sgp_xrates_d_sap_20221105_20221234567812.dat

 

Expected Output:

 

Need to fetch the data after the first / and need to remove the values that starts with 2022* and the word "EXEMPTION" as well.

 

3 REPLIES 3
Emmanuel_G
13 - Pulsar

Hi @BRRLL99 ,

 

Can you outline the output you want even for just a few lines?

BRRLL99
11 - Bolide

Hi

I want the output like this

 

olybl_ion
APR_TLM_FXCASH_SYS_Fwd
GLASS_APAC_CDGL_DAILY
GLASS_APAC_CDGL
t240287bl_1298672_
OPICS10390_BAL_KOR
s4_idn_sap_abcd_tcs_future
frontier_sgp_xrates_d_sap
markcurry
12 - Quasar

Hi @BRRLL99 

 

Hopefully this workflow will help.  There might be a nicer way.  

 

Regex101 breakdown

 

Mark

 

 

Labels