-
Notifications
You must be signed in to change notification settings - Fork 2
CSVReader
Steve Cote edited this page Mar 9, 2018
·
2 revisions
The Character Separated Value Reader reads not only RFC4180 Comma Separated Value (CSV) files, but any text file delimited with any character.
The minimum configuration for a CsvReader is a specification of the class and the source:
"Reader" : {
"class" : "CsvReader",
"source" : "demo/users.csv"
},
These are the configuration attributes supported by the component:
Attribute | Values | Description |
---|---|---|
class | CSVReader | This is the name of the class the engine is to load for the reader. |
source | URI or filename | The name of the file to read. |
header | true, false | True instructs the reader to treat the first line as the header. This will result in the fields being named as specified in the header line.False (the default) instructs the reader to treat the first line as data and will name each field will be named as "COL1, COL2...etc". |
character | "," or ";" etc. | The default character is the comma and the reader supports RFC4180 CSV file formats by default. Other delimiters can be defined. NOTE: if multiple characters are defined, only the first character will be used. |
preload | true, false | This instruct the reader to read the entire file into memory before sending the first frame through the engine. The default is false which instructs the reader to keep the file open and read one line at a time. |
- Concepts
- Features
- Transform Engine
- Quick Start
- Configuration
- Secrets Vault
-
Readers
- List of Readers
- Custom Readers
-
Writers
- List of Writers
- Custom Writers
-
Filters
- Accept
- Reject
- Custom Filters
-
Tasks
- List of Tasks
- Custom Tasks
-
Validators
- List of Validators
- Custom Validators
-
Listeners
- List of Listeners
- Custom Listeners
-
Transforms
- List of Transforms
- Custom Transforms
- Mappers
- Context
- Databases
- Templates
- Logging
- Encryption
- Usage
- Expressions
- Examples