Brian Dunning's FileMaker Custom Functions

FindRepetition ( searchString ; repeatingField ; start ; occurrence ; end ; partialMatch ; matchCase )

Calculates the repetition number where a search string can be found in a repeating field

  Average rating: 4.2 (37 votes) Log in to vote

Peter Wagemans   Peter Wagemans
Lesterius
https://www.lesterius.com

Share on Facebook Share on Twitter

  Sample input:
see http://www.clarify.net/viewtopic.php?p=14479#14479
  Sample output:
see http://www.clarify.net/viewtopic.php?p=14479#14479

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

FindRepetition ( searchString; repeatingField; start; occurrence; end; partialMatch; matchCase )

Because of the complexity of this custom function, an example file can be downloaded.
searchString: the string that is searched
repeatingField: a repeating field
start: the repetition from where to start searching
end: the repetition where to stop searching
occurrence: the nth repetition that matches the search criteria
partialMatch: 0 = equal, 1 = contains
matchCase: case sensitive search

 

Comments

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.