Concatenate

Concatenate function merges two or more data source values into a single value.

About group identifies the function.

  • Name: function ID, initially defined by the function type.

  • Description: function's purpose and role as defined by the user.

Input data source group defines the existing or newly added input data source (variable, function or database record) or fixed text that will be used in the function.

Output Options group defines the output value format.

Delimiter is a character that is inserted between the concatenated values. The delimiting character can be entered manually or selected from one of the additional options:

  • New Line (CR/LF): new line character.

  • Insert special character: special character is entered.

    Note

    Delimiter is an optional value. With no delimiter defined, the concatenated values are merged without a delimiting space or character.

  • Ignore empty values: ignores empty data source values. These values are excluded from concatenation.

    Tip

    This option is useful if you want to avoid duplicated delimiters if empty values appear.

Example 37. Example:

Data source value 1: A, B, C, D

Data source value 2: <empt>

Data source value 3: E, F, G

Delimiter: ,

Concatenated value with vs. without Ignore empty values: A, B, C, D, E, F, G vs. A, B, C, D, E, F, G

Note

Ignore empty values option is effective only after executing a print command. When storing a label in store/recall printing mode or when exporting a label, the empty values are not ignored. Delimiters appear duplicated.