This icon allows a user to specify how data is organised in an ASCII table file. Various formatting and reading options are available, allowing a wide variety of ASCII data tables to be parsed. See ASCII Tables for more details. This icon cannot be used standalone – it is intended to allow the construction of a table reader specification by editing the icon and then dropping it into the Macro Editor, where its equivalent Macro code will be generated. The data can then be used in a macro for further processing.
The macro language equivalent is read_table
()
.
The Table Reader Editor
Data
Drop any icon containing or returning table data.
Table Filename
Specifies the path to the input table file. This parameter, if filled, over-rides Data. Specifies the (single) character that separates values in the table. If On, then consecutive delimiters will be considered as one. This is often the case when whitespace is used to separate values which are aligned in columns. Note that in this case, it is not possible to represent missing values in the table. If Off, then a delimiter not surrounded by two data values indicates there is a missing value on at least one side of it. See the discussion in ASCII Tables for more details. Specifies which row of the table file contains the names of the columns. This row, if present, should contain the one entry for each data column, separated with the same delimiter as the data. The first row of the table is number 1. Set this parameter to 0 in order to indicate that there is no header row. Specifies how many rows after the header row the first data row appears. Normally this is 1, since data tends to start on the row after the column headers. If there is no header row, then this number is equivalent to the first data row (e.g. if the data starts on row 3, then set this parameter to 3). Specifies the rows (if any) which contain meta-data in a form which can be parsed by Metview. See ASCII Tables for more details. Enter the row numbers separated by a "/".Table Delimiter
Table Combine Delimiters
Table Header Row
Table Data Row Offset
Table Meta Data Rows
Table Columns
In order to conserve resources, it is possible to choose to load only a specified set of data columns. Enter the desired column numbers (the first column is numbered 1) separated by a "/".
Table Column Types
If Metview does not correctly determine the data types of the columns, this parameter makes it possible to specify the data types as a list of type names separated by a "/". Possible type names are "number" and "string". If Table Columns is set, only that subset of columns should be represented by the list of types.