


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
Solved! Go to Solution.
Views
Replies
Sign in to like this content
Total Likes
Hi Michelle,
You can try a formula like this Substring(Filename($(vars/@filename)),1,Length(Filename($(vars/@filename)))-23)
Hi Michelle,
You can try a formula like this Substring(Filename($(vars/@filename)),1,Length(Filename($(vars/@filename)))-23)
Views
Replies
Sign in to like this content
Total Likes
Hi David - where would this formula go?
Views
Replies
Sign in to like this content
Total Likes