16.20 - CSVLD - Advanced SQL Engine - Teradata Database

Purpose

CSVLD (Comma-Separated Value Data Loading) takes in a comma-separated string produced through the CSV table function, parses the string, and returns VARCHAR columns.

Syntax

TD_SYSFNLIB.

Name of the database where the function is located.

data_string_value

A string argument.

delim_string_value

A character expression.

A comma (,) is the default delimiter character.

quote_string_value

A character expression.

The quotation mark character, for example “”, is used to indicate that the delimiter character is a part of the value, and not a field separator.

The value inside the quote_string_value is returned as output exclusive of the quote_string_value given.