Splitting Arrayed String into Table Function on HANA

Do you ever imagine how much struggle you have to go through, just for splitting long string into one column in table?

Please take a look to this example:

You have a string like this

“AAA|BBB|CCC|DDD|EEE|FFF|GGG|HHH”

And you want to convert those string into one column like this:

Col 1

AAA
BBB
CCC
DDD
EEE
FFF
GGG
HHH

We have a quick solution for this.

Now you can create function (returns table) to split those string, with only one string input parameter.

And this function will return it as a table that you can join in your query.

Also read:

• Copy Table Function
• New Columns and Editable G/L Account on Purchase Request Report
• Sort Function on the Open Item List Does Not Appear
• Table not found Company Info(CINF)(ODBC-2004)