For some requirements it might be required to split string into table rows in Teradata

Teradata: Split String into table rows

There are 2 similar functions available to Split strings into a table using characters or regexp_string as the delimiter.

Note: Below examples & syntax are for Teradata 15 and above (there is different syntax in Teradata 14)



STRTOK_SPLIT_TO_TABLE



REGEXP_SPLIT_TO_TABLE