Make Table from Text (vuo.table.make.text)

Turns CSV- or TSV-formatted text into a table.

You can use this node to import data from a spreadsheet. In your spreadsheet application, export the data in CSV (Comma-Separated Values) or TSV (Tab-Separated Values) format. See vuo.table for more information on these formats.

Each line of the input text (except empty lines) becomes a row of the table. Within a line, each comma or tab marks the end of a column.

Spaces surrounding commas or tabs are ignored (unless enclosed in quotes).

If some rows have more columns than others, the output table has as many columns as the widest row. Columns that weren’t present for a row in the input text are populated with empty text in the output table.

If the text is formatted incorrectly, this node outputs an empty table. Check Vuo’s Console window (Tools > Show Console) for details about the error.

Keywords: column, comma, convert, csv, grid, parse, read, row, separated, spreadsheet, string, structure, tab, tsv

Example compositions:

• Change Table Data to Metric: Changes temperature data in a table from Fahrenheit to Celsius, and saves the modified table to a CSV file. This composition does not display a window. Data source: Coldest recorded temperature on each continent from https://en.wikipedia.org/wiki/List_of_weather_records
• Graph Coldest Temperatures: Draws a graph of temperatures (in Celsius) by location, ordered from warmest to coldest. Data source: Coldest recorded temperature on each continent from https://en.wikipedia.org/wiki/List_of_weather_records
• Perform Coin Flip Experiment: Simulates a series of coin flips and saves the results to a CSV file. In each of 15 trials, a coin is flipped 10 times, and the number of times it came up heads is recorded. This composition does not display a window.