ARRAYTOTEXT
Description
Converts an array of values into a single text string.
This function is useful for displaying array contents in a readable text format or converting array outputs for text-based operations.
Syntax
ARRAYTOTEXT(
array
, [format
])- array: The array to return as text.
- format: The format of the returned data. Options include:
- 0 (default): Concise format that is easy to read.
- 1: Strict format that includes escape characters and row delimiters.