Regex

Question

Hi

I have following input

/tenants/ct/108251/prod/rec/processing/apac_me/GLASS_CDGL_APAC_MONTHLY_20220831_CD01_20220901222348 EXCEPTION_20220901222916.CSV /tenants/ct/108251/prod/rec/processing/apac_me/GLASS_DYNAMO_2022-08-21-20220205_20220204210647.CSV

Required Output:

GLASS_CDGL_APAC_MONTHLY_CD01.CSV
GLASS_DYNAMO.CSV

flying008 · Answer

Hi, @BRRLL99

Dear, Why are you still struggling with this problem? Try the following expression, it may surprise you.

(((?<=\d|\/|^\s)(_?[A-Z]+[A-Z\d_]+?)(?=_20))|(\.[A-Z]+?$))

*********

If this answer is what you want, please mark it as solution to help more people.

BRRLL99 · Answer

i don't see any Filegettext function

MarqueeCrew · Answer

@BRRLL99 ,

if you want to preserve the desired output, yes I would use the formula tool.  You will combine the two expressions to get the file name plus the file extension consented together.

cheers,

mark