Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

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.

Sample Query – Splitting array string and return as table

 

 

, ,