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
Anchor-Buoy Software, LLC
http://www.anchorbuoysoftware.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.

Under construction. Email me your wish list for improvements.