Read_Text_Grid (Rd_Txt_Grid)
Synopsis
Reads in grid-oriented text, often the result of exporting a spreadsheet
Input Port
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