Shopping Cart
Contact
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
FieldBeginsWith ( Text ) Rate this function:   Discuss this Custom Function Andrew Persons, Excelisys Creates a multikey field containing all the increments of the beginning of the supplied text.
Description: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. Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems. This is my Custom Function and I want to edit it Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
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 ) =
If (
Length ( Text ) > 3 ; //only explode a string down to 3 characters
ExplodedKey ( Left ( Text ; Length ( Text ) - 1 ) ) & "¶" & Text ;
Text
)
Bill Doerrfeld, Seattle
September 04, 2009 5:43pm