ETL: CSVSPLIT

Parse a CSV-formatted string into a tuple by splitting on a field delimiter character. Use CSVSPLIT for inline CSV parsing in ETL pipelines.

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.