CSVSPLIT

Description

Splits a CSV string into a tuple around matches of a field delimiter.

Syntax

CSVSPLIT(csv_record, field_delimiter, [string_qualifier])

Arguments

  csv_record - string expression of a single csv row

  field_delimiter - the delimiter character used to separate fields.

  string_qualifier - the character that is used to enclose values that contain the delimiter character. Optional.

Examples

CSVSPLIT('Mary,had,a,little,lamb',',') returns a tuple (Mary,had,a,little,lamb)

Return value datatype

Tuple

Impact of null value

If input is null, returns null.