LastIndexOf ( text ; chars )

Search text from right to left.

Average rating: 4.4 (27 votes) Log in to vote

Lin Feng
None
None

Sample input:

LastIndexOf("ABC,XYZ,UVW"; ",")

Sample output:

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

if(isEmpty(text);
	0;
	if(PatternCount(chars; right(text; 1))>0;
		length(text);
		LastIndexOf(left(text; length(text)-1); chars)
	)
)

Search text from right to left.

Comments

		Tim Anderson, Tim Anderson Group Mar 11, 2015
How about Position (text; chars ; length(text); -1)

		unix, Japan Apr 2, 2015
You are right if chars is a char. If chars is not a char, Position ( text ; Right ( Filter ( text ; chars ) ; 1 ) ; Length ( text ) ; -1 ) This use Filter() , so not recursive but case sensitive. for compatible Position ( text ; Right ( Filter ( Upper ( text ) ; Upper ( chars ) ) ; 1 ) ; Length ( text ) ; -1 )

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