Tips and Tricks

Joins an unknown number of values together, with more complex separation rules to form a proper sentence from a data set. This function is very similar to Join(), except that it allows you to specify a different separator to use before the last item joined.

For example, you can create a comma separated list with the final item separated with the word ‘and’, such as ‘red, green, yellow and blue’.

Usage:

JoinAnd( s, l, r )

Parameters:

s

The separator is used to separate all but the last item.

l

The separator used for joining the last item.

r

This is a reference to a question in a repeating page, repeating section or multiple row data source

Example:

The example below returns a properly formed sentence:

JoinAnd(", "," and ",[Q1.Colours])
 

Related Articles

Keywords

Design Format Formula