AllTextCombinations(theText)
Rate this function: Average rating: 4.3 (7 votes) Discuss this Custom Function
Peter Gort, Denbigh International
http://www.denbigh.com.au
recursively subsets a text string into all possible subsets, return delimited, suitable for multikey right side of Portal search relationships
Sample Input:
|
Sample Output:
effort
effor
effo
eff
ef
e
f
ff
f
f
ffo
ff
f
f
fo
f
o
ffor
ffo
ff
f
f
fo
f
o
for
fo
f
o
or
o
r
ffort
ffor
ffo
ff
f
f
fo
f
o
for
fo
f
o
or
o
r
fort
for
fo
f
o
or
o
r
ort
or
o
r
rt
r
t |
|
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.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
GroupRelationInfo ( FileTarget ; TableTarget ; Result ) |
| |
(Tue, Mar 16, 5:57am) |
| 2. |
GeoBox(latitude;longitude; radius) |
| |
(Mon, Mar 15, 11:04am) |
| 3. |
MonthNameList ( start; number; short ) |
| |
(Sun, Mar 14, 11:45pm) |
| 4. |
matchListAB( ListA ; ListB; match_Value; match_operator ; getN ) |
| |
(Sun, Mar 14, 10:29pm) |
| 5. |
Bin2Hex ( binary ) |
| |
(Sat, Mar 13, 10:08pm) |
| 6. |
SlideView (text) |
| |
(Sat, Mar 13, 8:40pm) |
| 7. |
HashFNV1a64 ( text ; empty ) |
| |
(Sat, Mar 13, 6:23pm) |
| 8. |
HashFNV1a32 ( text ; empty ) |
| |
(Sat, Mar 13, 5:55pm) |
 |
|