Teradata: Split String into multiple columns and Vice Versa

Teradata: Split String into multiple columns and Vice Versa

There are table functions available which Split strings into multiple columns or concat multiple columns into single string/column using delimiter character/s.
➠ CSVLD: This functions takes in a delimited string (any delimiter can be passed), parses the string and returns multiple VARCHAR columns.

Syntax: 
CSVLD(tablename.column_to_split, delimiter, quote_string)



➠ CSV: This functions accepts multiple input columns as input and returns delimited string value merging all the columns with specified delimiter character.

Syntax: 
CSV(NEW VARIANT_TYPE(tablename.colum1,tablename.column2 [,tablename.columnN]), delimiter, quote_string)
Note: Most of the datatypes are supported except CLOB