Hi,

I have a field with a file path and I want to extract just a word from it, how I do it?

Example:

file: //Mac/Users/Me/Documents/Images/ProjectA/sculptures/A1.jpg

returns: sculptures

file: //Mac/Users/Me/Documents/Images/ProjectB/photographs/File5abc.jpg

returns: photographs

Edited June 7, 200817 yr by Guest
more explicit

will that word be always the last folder in the path (before the filename)?

will that word be always the last folder in the path (before the filename)?

Well, yes, that last folder name is what I need now.

The last part, the file name, is different every time and have different number of characters. BTW, once I get to know how to get that last folder name of the path maybe I would try to get the previous folder name as well :

TIA

Try this:

Let

([

list = Substitute ( path ; "/" ; ¶ ) ;

values = ValueCount ( list )

];

GetValue ( list ; values - 1 )

)

Hi Hare,

It worked!

Thanks, I appreciate your prompt response.

Cheers