We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Regex

BRRLL99
9 - Comet

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
9 - Comet

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