Substring dynamic filename

michellelowsl

26-06-2020

Hi there,

 

I'm trying to create dynamic audience label using the filename from file downloaded from SFTP. However the filename came up as full path. How can I substring $(vars/@filename) to leave just the filename removing the path and file extension?

 

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

DavidKangni

MVP

28-06-2020

Hi Michelle,

 

You can try a formula like this Substring(Filename($(vars/@filename)),1,Length(Filename($(vars/@filename)))-23)

Answers (0)