CSV Parser Transformation
Plugin version: 2.11.0
Parses an input field as a CSV Record into a Structured Record. Supports multi-line CSV Record parsing into multiple Structured Records. Different formats of CSV Record can be parsed using this plugin. Supports these CSV Record types: DEFAULT
, EXCEL
, MYSQL
, RFC4180
, Tab Delimited
, Pipe Delimite
and Custom
.
Configuration
Properties | Macros Enabled? | Description |
---|---|---|
Input field to Parse | No | Required. Specifies the input field that should be parsed as a CSV Record. Input records with a null input field propagate all other fields and set fields that would otherwise be parsed by the CSVParser to null. |
Format | No | Optional. Specifies the format of the CSV Record the input should be parsed as. |
Custom Delimiter | No | Optional. Custom delimiter to be used for parsing the fields. The custom delimiter can only be specified by selecting the option ‘Custom’ from the format drop-down. In case of null, defaults to “,”. |
Output Schema | No | Required. Specifies the output schema of the CSV Record. |
Created in 2020 by Google Inc.