Read CSV


Synopsis

This operator can read csv files.


Description

This operator can read csv files, where all values of an example are writen into one line and separated by an constant separator. The separator might be specified in the column separators parameter. The default will split the line on each comma, semicolon and blank. Arbitrary regular expressions are usable as separator. Empty values and the question mark will be read as missing values. You can quote the values (including the column separators) with a double quote ("). You can escape the quoting character with a backslash, i.e. \".

The first line is used for the attribute names as default, controlled by the use first row as attribute names parameter. This operator tries to determine an appropriate type of the attributes by reading the first few lines and checking the occuring values. If all values are integers, the attribute will become integer, if real numbers occur, it will be of type real. Columns containing values which can't be interpreted as numbers will be nominal, as long as they don't match the date and time pattern of the date format parameter. If they do, this column of the csv file will be automatically parsed as date and the according attribute will be of type date.


Input


Output


Parameters


ExampleProcess