Tips and Tricks 

Joins an unknown number of values together, and separates each with one or more specified characters. This is useful for creating lists from a data set, commonly these would be comma separated.

For example, consider a data set containing a list of countries. The Join() function can convert that data set into a comma separated list, or a list divided into separate paragraphs for creating a bullet list in the document.

Usage:

Join( s, r )

Parameters:

s

The Separator is used to separate the items in the second parameter.

r

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

Example:

The example below creates a comma separated list of countries.

Join(chr(44),[Q1.Country])
 

Related Articles

Keyword

Design Format Formula