The purpose of functions is to manipulate the data that is assigned to label objects. Functions process the existing data source values and store the result in function-generated data sources.
Each function can be directly connected to an object and used as a part of another function.
Desktop designer includes the following function types:
-
Concatenate: merges two or more data source values into a single value.
Concatenate function merges two or more data source values into a single value.
About group identifies the function.
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 15. 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