CONCATENATE

The CONCATENATE function allows you to easily join multiple string values and deal sensibly with NULL\empty strings.

Note: not to be confused with the CONCAT SQL syntax function.

CONCATENATE( <Ignore Nulls True/False> , <Characters to split data with> ,  <Field or Variable 1> [ , <Field or Variable 2> [ , <Field or Variable 3> ..... ] ] )

  • Ignore Nulls True/False: Enter True to ignore Null values or False to include them in the target string

  • Characters: The characters to use as separators between field values to be concatenated

  • Field/Variable: The field, or fields, to concatenate together.

Limitations

While there is no limit to the number of fields that can be concatenated together, there is a limit of characters in the Virtual Field expression of 4096 characters.

Example: create a field on the Individual table that returns a persons full name using separate fields provided by the source data.

CONCATENATE( True, " ", Individual Title, [Individual.Name First], [Individual.Name Last] )