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
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
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.