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.