FieldBeginsWith ( Text )
Creates a multikey field containing all the increments of the beginning of the supplied text.
Average rating: 4.0 (39 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Creates a multikey field containing all the increments of the beginning of the supplied text. This is useful for such cases as creating a multikey field for type-ahead (clairvoyance) applications.
Bill Doerrfeld, Seattle
Sep 4, 2009
AKA ExplodedKey() as created by Andy LeCates
A useful derivative is to restrict the length to prevent adding 1 or 2 character "words" to the key field index.
//ExplodedKey ( text ) =
Length ( Text ) > 3 ; //only explode a string down to 3 characters
ExplodedKey ( Left ( Text ; Length ( Text ) - 1 ) ) & "¶" & Text ;
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.