JoinRepetitions ( repeatingField ; delimiter ; start ; nRepeats )
Returns all repetitions in the repeating field as combined string
Average rating: 3.9 (34 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns all repetitions in the repeating field as string, combining the
repetitions with the given text in 'delimiter'
repeatingField - the repeating field you want combined
delimiter - the textfield or constant you want to use to combine the values
start - the starting repetition number. if < 1, the first repetition is assumed
nRepeats - the maximum number of repetitions you want joined
Return type: Text
Special thanks to Ari M. Weinstein who enhanced the function to prevent the delimiters from appearing when a repetition is empty.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.