Substring dynamic filename

3 replies
2094 views
Translate All

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

DavidKangniAccepted solution

Adobe Champion and Community Advisor

Hi Michelle,

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

David Kangni

DavidKangni

Accepted solution

Adobe Champion and Community Advisor

Hi Michelle,

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

Translate

David Kangni

M

michellelowslAuthor

Level 3

It works. Thanks so much!

Translate

Sign up

Login with SSO

Login to the community

Login with SSO