concatLong

concatLong, aggregator function

def process concatLong(value: text): text

Concatenates text values in an explicit order. If the result would exceed 256 UTF-8 bytes, concatLong truncates the result at a Unicode code point boundary and appends an ellipsis character. Use concat when overflow should fail instead of being truncated.

Examples

table T = extend.range(40)
T.Part = "abcdefghij"

result = concatLong(T.Part) sort T.N

show scalar "Truncated text" with result

Remarks

The concatLong function requires sort or scan to specify the order in which values are concatenated.

The result is still an Envision text value and is limited to 256 UTF-8 bytes. Truncation preserves Unicode code point boundaries.

See also

User Contributed Notes
0 notes + add a note