# joinRepeatingVariable ( variableName ; delimiter ; startIndex ; endIndex )

Join / concatenate a repeating variable / array using a delimiter character

Average rating: 3.9 (55 votes) Log in to vote

Sam Barnum 360Works http://360works.com |

Sample input:

joinRepeatingVariable("$$foo" ; ", " ; "" ; "")

Sample output:

FOO, BAR, BAZ

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

Join a repeating variable / array with a delimiter, using recursion.

If endIndex is not specified or is negative, the recursion will exit on the first empty element in the array. Otherwise, empty elements will be included in the results until endIndex is reached.

## Comments

Bruce Robertson Mar 14, 2011 |
||

Also works for repeating fields! | ||

Bruce Robertson Mar 14, 2011 |
||

The CF assumes that N for $var[N] is positive. Actually (unlike repeating fields) it can be zero; or negative; though it must always be an integer. In practice I suppose negative or zero values for N are rare. | ||

Sam Barnum, 360Works Mar 14, 2011 |
||

Interesting point, Bruce. If this function were to support negative indices, the empty-arg approach would require a way to iterate backwards to find the first non-empty value. Currently if no startIndex is specified 1 is assumed. | ||

David Walton, Wellfleet, MA Jun 27, 2011 |
||

Perfect. Thank you Sam! | ||

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