ExplodedString ( Field )
Generates a multi-key field containing all leading characters of each word from a string of text entered into a text field.
Average rating: 4.2 (34 votes) Log in to vote
|
David Woodyard Woody Digital http://www.woodydigital.com |
Returns:
w
wh
wha
what
t
th
the
h
he
hec
heck
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Based on the MultiFieldExplode custom function introduced to me by Chad Adams. Instead of multiple fields, this function works on a single field with multiple words. You'll need to trap for a single word occurrence as well as any paragraph returns.
Requires the original custom function "ExplodedKey" which was introduced to me by Andrew LeCates.
ExplodedKey ( Text ) =
If (
Length ( Text ) > 1 ;
ExplodedKey ( Left ( Text ; Length ( Text ) - 1 ) ) & "¶" & Text ;
Text
)
Comments
 |
Tim Griffith Feb 26, 2012 |
|
| What a piece of garbage. It simple does not work! | ||
|
Osmair, Palhoça, SC - Brazil Feb 8, 2013 |
|
| Thank you, worked perfectly If ( Length ( Text ) > 1 ; ExplodedKey ( Left ( Text ; Length ( Text ) - 1 ) ) & "¶" & Text ; Text ) |
||
|
Lisa H, Santa Cruz CA Aug 24, 2017 |
|
| Would love to have this reversed for use in a fast-find situation so user can type in any string of characters that they're looking for like this: wizard izard zard ard rd d and so on. Then a repeating find operation can whittle down a list of records really fast even if the string is from the middle of a word. Anyone got something like that? --Lisa |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.