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

Share on Facebook Share on Twitter

  Sample input:
  Sample output:

  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



Log in to post comments.


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

Under construction. Email me your wish list for improvements.