GetItemName ( Path )

Gives back the name of a file or a folder from a path

Average rating: 4.2 (5 votes) Log in to vote

Christophe Cossement
Lemon Pie
http://www.cobraradiobrewery.com

Sample input:

Get ( DocumentsPath )
/User/.../Documents/Test.txt
/User/.../Documents/Test/

Sample output:

Documents
Test.txt
Test

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
This function changes the "/" in a path to "¶" to get a list, then gives the last element of this list
*/

RightValues (
Case(
Right ( Path; 1 )= "/";
Substitute ( Left ( Path  ; Length ( Path  )-1 ); "/" ; "¶" );
Substitute ( Path ; "/" ; "¶" )
)
;1)

This function changes the "/" in a path to "¶" to get a list, then gives the last element of this list

Comments

		comment, VR Jan 22, 2017
RightValues ( Substitute ( path ; "/" ; "Â¶" ) ; 1 ) would have worked just as well. Let ( v = Substitute ( path ; "/" ; "Â¶" ) ; GetValue ( v ; ValueCount ( v ) ) ) would work even better, since it would return the last token witout a trailing carrige return.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetItemName ( Path )

Comments

Support this website.

Support this website.