Read_Text_Grid (Rd_Txt_Grid)

Synopsis

Reads in grid-oriented text, often the result of exporting a spreadsheet

Input Port

parent

UIconnection

Parameters

Filename	UIfileSB	name of the file to read
skip lines	UIfield	number of lin es to skip
has header line	UItoggle	if set, use header to get column names
has row header	UItoggle	if set use the header to get row names
column separator	UIradioBox	selects column separator
user separator	UIfield	custom column separator
data type	UIradioBox	selects the data type of the field's nodedata
Read File	UIbutton	causes file to be read

Output Port

field

Mesh_Unif+Node_Data

Description

Read_Text_Grid (the Network Editor name is shortened to Rd_Txt_Grid), reads in grid oriented text into a uniform field. The data files are often the result of exporting a spreadsheet or database into a text format. The reader will attempt to the structure (number of rows and columns)of the data by looking at the data file. Each row of data is assumed to end with a line termination character. The columns are assumed to be separated by the column separator character, often a tab, space, or comma. If the data type is "from file" the reader will look at the file to guess between integer and double (floating point).

Other than the column and row headers, the file is treated as a uniform grid of numerical data. If you need to customize the actions of the reader on a column-by-column basis or some of the data are character strings, then use Read_Text_columns (Rd_Txt_Columns in the Network Editor) instead.

Input

parent

The UI parent, of type UIconnection.

Parameters

Filename

A file dialog box in which you select the file to read.

skip lines

An integer that specifies the number of lines in the file to skip. The default is_0.

has header line

A toggle that causes the module to treat the first line (after skipping the number of lines specified by the skip lines parameter) as a header that contains column names. The default is OFF.

has row header

A toggle that causes the module to treat the first row (after skipping the number of lines specified by the skip rows parameter) as a header that contains row names. The default is OFF.

column separator

A choice of characters to use as column separators. The allowed values are "space", "tab", ",", ";", ":", and "user". If you select "user", the value specified for the user separator parameter is treated as the column separator.

user separator

A string that specifies a character or sequence of characters to be used as column separator.

This parameter is relevant only if you have also selected "user" in the column_separator parameter.

data type

Radio box items that specify the type of the output data for the field's node data. The allowed values are byte, short, int, float, double, and string.

Read File

A button to activate the module.

Output Port

field

Mesh_Unif+Node_data. The output is a new Uniform Field.

Example

Not available

File

v/modules.v

See also related modules

table_to_scattered_field

table_to_uniform_field