CSV (Comma Separated Value) Reader Parameters

This parameter allows you to choose different naming schemes, and the number of feature types generated for the reader.

Feature type name choices:

• From File Name(s): Generates one feature type per source filename.
• From Format Name: Produces only a single feature type containing the format name.

The single character or tab character specified as the separator for the values on a line.

If selected, multiple contiguous delimiters are treated as a single delimiter; otherwise, each delimiter is treated as if it delimits a different field.

Some CSV files place quotation marks around all values they contain. By default, this option is selected and quotation marks will be stripped from column values.

If the field or column names of the CSV table are specified in the file, this option ensures that the names will be extracted from the file. Otherwise, the columns of the CSV table are given default names (that is, col0, col1, ... , colN). If the source dataset contains field names, this parameter will be selected by default.

If the column/field names appear AFTER the header information instead of BEFORE, you can select this option. Otherwise, by default, the first line of the file will be used as the column/field names.

Note: This parameter is ignored if Has Field Names is not checked. If Field Names Follow Header is selected, Lines to Skip should also be set to skip at least one row, or the first row will be also be processed as a feature.

This parameter sets the number of lines to skip at the top of the file. By default, 0 lines are skipped.

Each line skipped is logged to the log file. This is useful if the CSV file contains a header line of field names or other descriptive material (like comments) that should be skipped.

This parameter sets the number of footer lines to skip at the bottom of the file. By default, 0 footer lines are skipped.

Each footer line skipped is logged to the log file. This is useful if the CSV file contains a footer line of descriptive material that should be skipped.

If the field structure of the first several rows of a file is representative of the remainder of the file, this option can be set to prevent FME from unnecessarily reading further rows from a potentially large file when determining its schema.

If this is set to 0, there will be no limit and all rows will be read.

Note: This setting only applies to the schema generation; it does not limit the number of rows read when the translation is run.

This section defines the fields, methods, and directions to use to sort the CSV dataset. If you select this checkbox, features will be produced in the order defined by the parameter values. Once sorting is complete, features will be output from the reader in sorted order.

Values: <Field Name>, <Numeric | Alphabetic>, <Ascending | Descending>

This parameter requires information in both Field Names and Filter fields. If not specified, it will filter by the default Filter Matching choice.

Field Name

Defines which fields of the CSV dataset will be used to filter rows on read.

Filter

Contains the regular expression that will be applied to the selected Field Names. Depending on the value of the Filter Matching parameter, the CSV reader will either ignore rows that match the filter, or only read rows that do match the filter.

Some examples are shown in the table below:

Invert Filter

Defines whether the CSV reader will look for the presence or absence of the given regular expression when producing features.

If this parameter is not selected, the CSV reader will only consider rows that contain the specified regular expression when producing features.

If the parameter is selected, the CSV reader will ignore rows that have a field name which matches the regular expression.

When filtering, the CSV reader will only produce features for rows that match all of the specified filters.

This specifies the file encoding to use when reading.