regex? fullpath to filename only

[PassION_es]

Hello Alteryx,

I want to get only the filename (highlighted in yellow) of the output from batch macros (consolidated sheets/workbook).  Is this can be done in Regex as well? Thanks

[ChrisTX · Accepted solution]

Try this

Chris 

[binu_acs · Accepted solution]

@PassION_es  regex for getting only the file name

REGEX_Replace([FileName], '.*\\(.*)\|\|\|.*', '$1')

[PassION_es]

Thanks @ChrisTX @binu_acs