ArrayToString
The ArrayToString() function returns a string representation of a range. Delimiters are used to indicate the start of rows or columns in the output string. Each delimiter can consist of one or more characters.
Related functions: StringToArray, SubstituteArray, TransposeArray
Syntax:
Qx.ArrayToString(Range, Row Delimiter, Column Delimiter)- In Excel with Quintessence addin versions prior to 25.1, use:
ArrayToString() - In the Quintessence Editor (Studio) using Quintessence language, use:
ArrayToString() - In the Quintessence Editor (Studio) using Python language, use:
Qx.ArrayToString()
ⓘ See parameter descriptions
| Range | The range to manipulate. |
| Row Delimiter (optional) | The character sequence that indicates the beginning of a row in the output string. |
| Column Delimiter (optional) | The character sequence that indicates the beginning of a column in the output string. |
Remarks:
- Unless changed by an administrator, the default parameters are:
- Row Delimiter: No character is used as a row delimiter.
- Column Delimiter: No character is used as a column delimiter.
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Concatenation using ; and , as row and column delimiters
Suppose we want to convert the following array (located in Excel at range A1:D4) into a string, using ; as the row delimiter and , as the column delimiter:
| 10 Jan 2001 | 11 Jan 2001 | 12 Jan 2001 | |
| ABC1 | 100 | 101 | |
| ABC2 | 56 | 55 | 59 |
| ABC3 | 67 | 70 |
This can be achieved by calling the function as follows:
=Qx.ArrayToString(A1:D4, ";", ",")The result is (dates are returned as numeric values):
| ,36901,36902,36903;ABC1,,100,101;ABC2,56,55,59;ABC3,67,,70 |