From 3:00AM CST Saturday, August 15 – 10:00PM CST Saturday August 15, will be undergoing system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

Table Of Contents

Spreadsheet String to Array (G Dataflow)

Last Modified: January 12, 2018

Converts a delimited string of values into an array of strings or numbers.


format string

A string that uses format specifiers to determine how to convert the text into array data. Use %s to convert spreadsheet string to an array of strings. Use %d or %f to convert spreadsheet string to an array of numbers.


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: 2D array of double-precision, floating-point numbers



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: \t — single tab character



An array of the dimension and representation of array type containing the delimited data from spreadsheet string.

Converting to 1D String Arrays

If you want to more quickly convert a delimited string to a 1D string array, use Delimited String to 1D String Array.

Where This Node Can Run:

Desktop OS: Windows

FPGA: All devices (only within an optimized FPGA VI)

Web Server: Supported in VIs that run in a web application

Recently Viewed Topics