16.10 - Rules for Parsing - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)
  • If values are unquoted, scan for the delimiter or end-of-line, since these are the only significant characters.
  • If values are always quoted, the following rules apply:
    • At the start of the input line, or after a delimiter, an open quote must be present; otherwise, it is a malformed input line.
    • Following an open quote, all characters become part of the data value, with the following exceptions:

      A doubled close quote – causes one close quote to become part of the data value. The DataConnector operator supports this behavior automatically so that you do not need to specify a quote as the EscapeQuoteDelimiter attribute.

      A backslash-escaped close quote – causes the escape backslash to be discarded and the close quote to become part of the data value.

      A backslash-escaped backslash – causes the escape backslash to be discarded and the second backslash to become part of the data value

      An undoubled, unescaped close quote – terminates the data value, and must be immediately followed by a delimiter or end-of-line.

  • If values are optionally quoted, the following rules apply:
    • At the start of the input line, or after a delimiter, if an open quote is present, the value is quoted and the rules above for always-quoted values apply.
    • Otherwise, the value is unquoted, and the rules above for unquoted values apply.