Substring dynamic filename

[michellelowsl]

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

[DavidKangni · Accepted solution]

Hi Michelle,

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

[michellelowsl]

It works. Thanks so much!

[rebeccateng12]

Hi David - where would this formula go?