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 - Show more from this author
Tony White Designs, Inc.
http://www.twdesigns.com/

Sample input:

value.index.ci ( "a¶b¶cd¶c¶d" ; "c" )

Sample output:

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

// lowercase so it does NOT look built in ; likewise uses . and _ characters
// case insensitive (.ci)

Let (
[ 
~list.padded = ¶ & a_list & ¶ ; 
~value.padded = ¶ & a_value & ¶  ; 

~position = Position ( ~list.padded ; ~value.padded ; 1 ; 1 ) ; 
~list.padded.left = Left ( ~list.padded ; ~position ) ;
~index = ValueCount ( ~list.padded.left ) ;

~result = ~index

] ; 
~result
)

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

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

value.index.ci ( a_list ; a_value )

Comments

Support this website.

Support this website.