Brian Dunning's FileMaker Custom Functions

value.index.ci ( a_list ; a_value )

Returns the index/row of the first (case insensitive) match of "a value" in "a list" of values

  Be the first to rate this function Log in to vote

Tony White   Tony White - Show more from this author
Tony White Designs, Inc.
http://www.twdesigns.com/

Share on Facebook Share on Twitter

  Sample input:
value.index.ci ( "a¶b¶cd¶c¶d" ; "c" )
  Sample output:
4

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

Returns the index/row of the first (case insensitive) match of "a value" in "a list" of values
Uses a variety of techniques to make the code readable:
• lowercase
• dot syntax
• _ characters in parameters
* Let function with ~ characters
• etc.

Part of a suite of functions that are name spaced "value.something"

 

Comments

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: