ArrayToString
The ArrayToString() function is used to return a string representation of a range. Delimiters are used to represent the start of rows or columns in the output string. The delimiters can be a sequence of one or more characters.
Related functions: StringToArray, SubstituteArray, TransposeArray
Syntax
ArrayToString (Range, RowDelimiter, ColumnDelimiter)
| Range | The range of Excel cells to manipulate |
| RowDelimiter | The character sequence that marks the beginning of a row in the output string |
| ColumnDelimiter | The character sequence that marks the beginning of a column in the output string |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Example 1. Concatenation using ‘;’ and ‘,’ as row and column delimiters
Example 2. Concatenation using ‘===’ and ‘++’ as row and column delimiters
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example 1. Concatenation using ‘;’ and ‘,’ as row and column delimiters
The ArrayToString() function is used to concatenate a selected range into a string. This example uses a semicolon as a row delimiter and a comma as a column delimiter.
| Range | To string | ||
| Basket | Code | Date | =ArrayToString(A2:C5,”;”,”,”) |
| 5030 | PHO | 2015-02-15 | |
| 5030 | BSF | 2015-02-15 | |
| 5030 | NHP | 2015-02-15 | |
| Range | Output | ||
| Basket | Code | Date | Basket,Code,Date;5030,PHO,2015-15-15;5030,BSF,2015-15-15;5030,NHP,2015-15-15 |
| 5030 | PHO | 2015-02-15 | |
| 5030 | BSF | 2015-02-15 | |
| 5030 | NHP | 2015-02-15 | |
Example 2. Concatenation using ‘===’ and ‘++’ as row and column delimiters
The ArrayToString() function is used to concatenate a selected range into a string. This example uses three equal signs as a row delimiter and two plus signs as a column delimiter.
| Range | Concatenate | ||
| Code | Date | Value | =ArrayToString(A2:C5,”===”,”++”) |
| BSF | 2015-03-31 | 65.36 | |
| BSF | 2015-04-01 | 66.3 | |
| BSF | 2015-04-02 | 67.2 | |
| Range | Output | ||
| Code | Date | Value | Code++Date++Value===BSF++2015-03-31++65.36===BSF++2015-04-01++66.3===BSF++2015-04-02++67.2 |
| BSF | 2015-03-31 | 65.36 | |
| BSF | 2015-04-01 | 66.3 | |
| BSF | 2015-04-02 | 67.2 | |