Brian Dunning's FileMaker Custom Functions

GetReduxList ( text ; isBreakOnWords ; minSearchChars ; maxSearchChars )

Explodes a piece of text into its constituent strings, for use in a partial-string match portal search feature.

  Average rating: 4.4 (22 votes) Log in to vote

Cristos Lianides-Chin   Cristos Lianides-Chin - Show more from this author
Codence
https://www.codence.com

Share on Facebook Share on Twitter

  Sample input:
GetReduxList ( "Alpha-Bravo-Charlie" ; 1 ; "3" ; "100" )
  Sample output:
Alpha-Bravo-Charlie
Alpha-Bravo-Charli
Alpha-Bravo-Charl
Alpha-Bravo-Char
Alpha-Bravo-Cha
Alpha-Bravo-Ch
Alpha-Bravo-C
Alpha-Bravo-
Alpha-Bravo
Alpha-Brav
Alpha-Bra
Alpha-Br
Alpha-B
Alpha-
Alpha
Alph
Alp
Bravo-Charlie
Bravo-Charli
Bravo-Charl
Bravo-Char
Bravo-Cha
Bravo-Ch
Bravo-C
Bravo-
Bravo
Brav
Bra
Charlie
Charli
Charl
Char
Cha

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Explodes a piece of text into its constituent strings, for use in a partial-string match portal search feature.

For more information on this search technique, see http://www.mindfiresolutions.com/Filter-portal-records-by-partial-matching-of-search-criteria-in-FileMaker-1022.php

 

Comments

Charlie Bailey   Charlie Bailey, Northampton, MA
Jul 14, 2015
Thanks Cristos - just what I needed.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: