Shopping Cart
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
Search | List | Show Random | Upload | Add This to Your Site |
||||||||||||||||||||||||||
|
AllTextCombinations(theText) Peter Gort, Denbigh International recursively subsets a text string into all possible subsets, return delimited, suitable for multikey right side of Portal search relationships
Description: In our solutions we commonly use "Search Portals" where the user enters a search criteria into a global and a multi key relationship displays matching records in a portal. In FM6 the field on the right side of the relationship was a long and complext calculation that had to be individually modified for each table. In FM7 we use a single custom function that calls itself recursively on subsets of the input text. This means that searching of text of _any_ length will work, not restricted to first 60 characters. Note that Filemaker recursion limit means text more than 15 characters long has to be chopped up and processed individually by the function. Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems. |
digg this page | del.icio.us this page
Custom Function Authors: |
|||||||||||||||||||||||||
