Regex

[BRRLL99]

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.

[Emmanuel_G]

Hi @BRRLL99 ,

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

[BRRLL99]

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 · Accepted solution]

Hi @BRRLL99 

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

Regex101 breakdown

Mark