How to extract text from a field?

[mirkovonberner]

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, 2008 by Guest
more explicit

[Hare]

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

[mirkovonberner]

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

[Hare]

Try this:

Let

([

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

values = ValueCount ( list )

];

GetValue ( list ; values - 1 )

)

[mirkovonberner]

Hi Hare,

It worked!

Thanks, I appreciate your prompt response.

Cheers