CsvToArray
The CsvToArray()
Syntax:
Qx.CsvToArray(Text)- In Excel with Quintessence addin versions prior to 25.1, use:
CsvToArray() - In the Quintessence Editor (Studio) using Quintessence language, use:
CsvToArray() - In the Quintessence Editor (Studio) using Python language, use:
Qx.CsvToArray()
ⓘ See parameter descriptions
| Text | Csv text. |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Convert CSV data to an array
Suppose we have the following CSV data in text format:
ABC1,2000-10-05,51
ABC2,2000-10-05,65This CSV text can be converted to an array using the following formula (assuming the CSV text is stored in a variable called csv_data):
=Qx.CsvToArray(csv_data)Result:
| ABC1 | 2000-10-05 | 51 |
| ABC2 | 2000-10-05 | 65 |