Spreadsheet String to Array
- Updated2023-02-17
- 2 minute(s) read
Spreadsheet String to Array
Converts a delimited string of values into an array of strings or numbers.
Inputs/Outputs
format string
A string that uses format specifiers to determine how to convert the text into array data.
spreadsheet string
A string containing numbers or text separated into columns by delimiters, such as tabs or commas, with an end-of-line (EOL) character separating rows.
This node converts each value in spreadsheet string according to format string and stores the resulting values in array.
array type
The data type that determines the dimension and representation of array.
Default value: 2D array of double-precision, floating-point numbers
delimiter
A character or string of characters used to separate fields in the spreadsheet text. For example, a value of , (comma) specifies a single comma as the delimiter.
Default value: \t — single tab character
array
An array of the dimension and representation of array type containing the delimited data from spreadsheet string.