Expand my Community achievements bar.

SOLVED

Substring dynamic filename

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Michelle,

 

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



David Kangni

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi Michelle,

 

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



David Kangni