Index Data Reader "Csv"
The index data reader "Csv" processes classic CSV files. Classic CSV files always have a record which has the same structure per line and which contains values separated by delimiters. As an option, the names of the fields can be listed in the first line of the file, always with same sentence structure. In .InputName, to reference the fields, enter these names. Otherwise, enter the index numbers of the fields as the data type "text." Counting starts at 1.
If records are not separated into individual documents beforehand using the CSV input format, the CSV file of a document might contain multiple lines. If an input field is then assigned to a header data field, either only the value of the first line or the values of all lines will be adopted as an array, depending on the .ReadMultiValues property. In the case of tabular target fields, the scalar value of each input line is assigned to a corresponding table line.
Property | Description |
|---|---|
ProcessReadIndex[].DefaultEncoding | Default value for the character encoding of the CSV file to be read in if this cannot be determined from the file using a BOM (byte order marker) (see Miscellaneous) Default value: |
ProcessReadIndex[].HeaderMode | Mode that indicates whether the CSV file contains headers with the field names:
|
ProcessReadIndex[].Separator | Single separator character used to delimit the field values from each other Default value: comma |
ProcessReadIndex[].Delimiter | Single field delimiter in which the values are embedded (e.g., quotation marks) (optional) By using the field delimiter, the separator can also be used within a field value. If used in a field value, enter the delimiter twice. In addition, a special syntax variant is allowed where only certain field values use the delimiter (e.g., only text values, but not numeric values). |