joinLong
joinLong, aggregator function
def process joinLong(value: text; delimiter: text): text
Concatenates text values in an explicit order, separated by the specified
delimiter. If the result would exceed 256 UTF-8 bytes, joinLong truncates the
result at a Unicode code point boundary and appends an ellipsis character. Use
join when overflow should fail instead of being truncated.
value: the text values to concatenate.delimiter: the text to insert between each pair of concatenated values.
Examples
table T = extend.range(40)
T.Part = "abcdefghij"
result = joinLong(T.Part; "-") sort T.N
show scalar "Truncated joined text" with result
Remarks
The joinLong function requires sort or scan to specify the order in which
values are concatenated.
The delimiter is inserted between consecutive values. Empty texts are included
in the output unless filtered out with when.
The result is still an Envision text value and is limited to 256 UTF-8 bytes.
Truncation preserves Unicode code point boundaries.