StringToArray
The StringToArray() function converts a string into a two dimensional array (a range of rows and columns) by splitting the string using specified delimiters. Both row and column delimiters may consist of one or more characters.
Related functions: ArrayToString, SubstituteArray, TransposeArray
Syntax:
Qx.StringToArray(Range, [Row Delimiter], [Column Delimiter])- In Excel with Quintessence addin versions prior to 25.1, use:
StringToArray() - In the Quintessence Editor (Studio) using Quintessence language, use:
StringToArray() - In the Quintessence Editor (Studio) using Python language, use:
Qx.StringToArray()
ⓘ See parameter descriptions
| Range | The string to be split. |
| 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:
- The default parameters are:
- Row Delimiter: No character is used as a row delimiter.
- Column Delimiter: No character is used as a column delimiter.
- Delimiters may be single characters or multi‑character strings.
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
>Example 1: Convert a string into an array using ; and , as row and column delimiters
String to convert:
, ,2000,2001,2002;ABC1,,100,101;ABC2,56,55,59;ABC3,67,,70Row delimiter: ;
Column delimiter: ,
Formula:
=Qx.StringToArray(",2000,2001,2002;ABC1,,100,101;ABC2,56,55,59;ABC3,67,,70", ";", ",")Result:
| 2000 | 2001 | 2002 | |
| ABC1 | 100 | 101 | |
| ABC2 | 56 | 55 | 59 |
| ABC3 | 67 | 70 |