Concatenate

Use the Concatenate function to combine multiple data sources and fixed texts in a single string. You can also define a delimiter character or string between data values.

To create the Concatenate function:

  1. Click the Data icon to open the Data Sources menu.

    89_data.png

  2. Expand the Functions drop-down menu, then click New Concatenate.

  3. The Concatenate function properties window opens. in the Definition section, you can define your function name and add a function description.

  4. In the Input data sources section, you must insert your data sources to concatenate. Click +Add button to add data sources to your function. You can concatenate variables, database fields, functions, and fixed texts.

    After you add your data sources, you can change the order using cursor icons, or remove data sources from the function.

    38_concate_1.png

  5. In the Output Options section, you can define a character or a set of characters that delimits data source values in your Concatenate function. Your delimiter can also include special characters.

    39_concate_2.png

    Ignore empty values option removes the delimiter if the variable value is empty.

To use the Concatenate functions with your label objects:

  1. Place the label object on the design surface.

  2. Click the object to open the object properties.

  3. In the Source section, select your concatenate function.

    73_concatenate.png

Your label object now presents the concatenation function value.