Brian Dunning's FileMaker Custom Functions

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

Theo Ros   Theo Ros

Share on Facebook Share on Twitter

  Sample input:
JoinRepetitions ( repeatingField ; "|" ; 1 ; 4 )
  Sample output:
"Apple | Banana | Orange | Cherry"

  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.



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.