Brian Dunning's FileMaker Custom Functions

ListIndex ( list ; string ; matchcase )

Seaches a list and returns the indexnumber if found

  Average rating: 4.6 (32 votes) Log in to vote

Theo Ros   Theo Ros
n/a
n/a

Share on Facebook Share on Twitter

  Sample input:
ListIndex ( "John¶Paul¶George¶Ringo" ; "ringo" ; False )
  Sample output:
4

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

Searches a Return delimited list 'list' for the occurrance of the given value.
Returns the 1-based indexnumber if found, 0 if value is not in the list.

Syntax: ListIndex ( list ; value ; matchcase )

In: list - the return delimited list to search
string - the string to look for in the item
matchcase - if True, the list is searched Case Sensitive
if False, a Case Insensitive search is performed

Return type: Number

 

Comments

Peter Sijmons   Peter Sijmons, Szienz
Mar 10, 2014
list has become a reserved word in FMP13 and can no longer be used as param
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.