concat fields within same node()
This function concatenates the values of all fields that exist within the same node and above of the current field, separated by delimiter a. If the delimiter is already present in a field value, the character is escaped with "\". Calculation fields, subnodes and the field itself, on which this function is set, are ignored. If the optional parameter b has the value "true", calculation fields are included.
Parameters
Parameter |
Description |
a |
(optional) Delimiter. If the value starts with "0x" (see examples), the character with the following hexadecimal Unicode value will be used. Default: ",". |
b |
(optional) "true" if calculation fields should be added as well. Default: "false". |
c |
(optional) If " false" is set and a field has a set Empty Flag , the function uses the hidden value of the field . If "true" is set, the function uses a string of spaces, whose length corresponds to the field length (→ see examples). Default: " false" . |
d |
(optional) Character/string to mask the delimiter if it occurs within the field values. Default: "\". |
Examples
The target node contains the following five fields and values above the current field with our function.
Counter (calculation field) |
Field1 |
Field2 |
Field3 |
Field4 (String field of length 3) |
1 |
Value1 |
Value2 |
Value3 |
<no value> ('') |
Parameter a |
Parameter b |
Parameter c |
Parameter d |
Result |
; |
|
|
|
Value1,Value2,Value3 |
; |
true |
|
|
1,Value1,Value2,Value3 |
0x20 |
false |
|
|
Value1_Value2_Value3_ (The space character is shown as an underscore here for display purposes.) |
0x20 |
false |
true |
|
Value1_Value2_Value3____ (The space character is shown as an underscore here for display purposes.) |