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.)