Substring dynamic filename | Community
Skip to main content
M
michellelowsl
Level 3
June 26, 2020
Solved

Substring dynamic filename

  • June 26, 2020
  • 1 reply
  • 2072 views

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.
Best answer by DavidKangni

Hi Michelle,

 

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

1 reply

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
June 29, 2020

Hi Michelle,

 

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

David Kangni
    M
    michellelowslAuthor
    Level 3
    June 29, 2020
    It works. Thanks so much!
    Terms & ConditionsAccessibility statement

    Loading footer...