CSV input format Delimited - available properties

These properties are available if the input format is Delimited:

  • Fields - Specify the names of the fields that are in the delimited data as a comma-separated list of field names, e.g. "id,name,age".
  • Input Field Delimiter - The character or string that delimits fields. If not specified, the default is the pipe character '|'.
  • Input Row Delimiter - The character or string that terminates a row. If not specified, the default is the newline character '\n'.
  • Input Escape Character - The character to escape field and row delimiters if they appear in the data. By default, there is no escape character. If the field and row delimiters cannot appear in your data, do not define an escape character, since doing so adds processing overhead.