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

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
amv1590702100517.ditamap
dita:ditavalPath
amv1590702100517.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.