GetValueIndex (FileMaker Pro Custom Function)

GetValueIndex (valueList, valueString, matchCase, occurrence):

Retrieve the index of the matching valueString in the valueList. Returns 0 if not found. Optionally, toggle case-sensitive searching by passing a boolean through matchCase, and, search for a specific
valueString occurrence (a negative occurrence number causes backward search from the end of the valueList).

Examples:
ValueListIndex (“Alpha¶Bravo¶Charlie¶Echo”, “charlie”, False, 1) = 3
ValueListIndex (“Alpha¶Bravo¶Charlie¶Echo”, “charlie”, True, 1) = 0
ValueListIndex (“Danial¶Daniel¶Bill¶daniel¶Frank¶daniel¶Ed”, “Daniel”, True, -1) = 2

This entry was posted in Custom Functions, FileMaker Pro, Software and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>