concat fields within same node(a,b,c,d)
|
Group |
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.
Description of 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) |