Split function in HANA

[yash_rastogi31]

Hello,

I am trying to create a function in HANA in which I want to apply the following logic:

Pass a comma separated string to the function and the function returns a table/list containing all the comma-separated strings.

Fox example, if I pass the string as ABC, DEF,GHI,JKL

then the function returns me a table having the following output in a column:

ABC

DEF

GHI

JKL

Thanks,

Yash

[acaireta · Accepted solution]

Hello,

Not find any similar function to split, but I attach a procedure to perform this task.

Regards.

DROP PROCEDURE SPLIT_TEST;

CREATE PROCEDURE SPLIT_TEST(TEXT nvarchar(100))

AS

BEGIN

  declare _items nvarchar(100) ARRAY;

  declare _text nvarchar(100);

  declare _index integer;

  _text := :TEXT;

  _index := 1;

  WHILE LOCATE(:_text,',') > 0 DO

  _items[:_index] := SUBSTR_BEFORE(:_text,',');

  _text := SUBSTR_AFTER(:_text,',');

  _index := :_index + 1;

  END WHILE;

  _items[:_index] := :_text;

  rst = UNNEST(:_items) AS ("items");

  SELECT * FROM :rst;

END;

CALL SPLIT_TEST('A,B,C,E,F')

[yash_rastogi31 · Accepted solution]

Hi Adria,

Thanks a lot for solving the query. It really helped a lot.

Regards,

Yash

[acaireta · Accepted solution]

Hi Yash,

I'm glad-I helped.

Please mark as answer to close the discussion.

Regards.

[danielschindler_com · Accepted solution]

This message was moderated.