Table Of Contents
Array to Spreadsheet String (G Dataflow)
Converts an array of any dimension to a delimited string that mimics a spreadsheet with rows, columns, and pages.
format string
A string that includes a single format specifier to determine how to convert each element of an array into text.
Each format specifier uses the following general syntax:
% modifiers specifier
This node allows only the following specifiers: s, d, and f. Use %s to convert an array of strings to spreadsheet string. Use %d or %f to convert an array of numbers to spreadsheet string.
Modifiers for Numeric Specifiers (x, o, b, d, u, f, e, g, p)
If you use multiple modifiers, they must appear in the following order:
%[-][+][#][0][width][.precision || _significantDigits]specifier
Modifiers for the String Specifier (s)
Use the following syntax to format a string:
%[-]width s
| Modifier | Definition |
|---|---|
| - | Left justifies the output within its width. If the node inserts spaces to create the specified width, the spaces appear to the right of the value. |
| width | A number specifying the minimum number of characters that the node uses in the output. If the value requires fewer characters, the node pads the output with spaces to meet this width. This width is not a maximum width. The node uses as many characters as necessary to output the value without truncating it. If width is missing or 0, the output uses only as many characters as necessary to contain the formatted value. |
Syntax for Literal Text Outside the Format Specifier
Most text you enter outside the format specifier appears literally in the output for each array element. However, you must use the following syntax if you want to output certain special characters.
| Syntax | Definition |
|---|---|
| \00 - \FF | Hex value of an 8-bit character; must be uppercase |
| \b | Backspace (ASCII BS, equivalent to \08) |
| \f | Form feed (ASCII FF, equivalent to \0C) |
| \n | Linefeed (ASCII LF, equivalent to \0A). Format into File automatically converts this code into the platform-dependent end-of-line character. |
| \r | Carriage return (ASCII CR, equivalent to \0D) |
| \t | Tab (ASCII HT, equivalent to \09) |
| \s | Space (equivalent to \20) |
| \\ | Backslash (ASCII \, equivalent to \5C) |
| %% | Percent sign |
array
The values to convert to text.
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: \t — single tab character
spreadsheet string
A string containing the data from array that mimics the table layout of a spreadsheet.
This string separates column elements with a specified delimiter, separates rows with a platform-dependent EOL character, and separates higher dimensions with a special header syntax of the form [highest dimension index, next highest dimension index, ... , 0, 0], where the final 0's refer to the first row and column elements of the page.
Converting 1D String Arrays
Array to Spreadsheet String appends end-of-line characters to define the spreadsheet string. If you want to convert a 1D string array to a delimited string without EOL characters, use 1D String Array to Delimited String.Where This Node Can Run:
Desktop OS: Windows
FPGA: All devices (only within an optimized FPGA VI)
Web Server: Not supported in VIs that run in a web application