17.10 - Example: Using CSV Data in Double Quotes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1198-171K
Language
English (United States)

Some CSV data fields are wrapped in double quotes, which is in line with the CSV specification at https://tools.ietf.org/html/rfc4180#section-2. A field or key is allowed to have a delimiter in it when surrounded by double quotes denoting the delimiter is part of the value.