HANA：字符串分割了吗？

Question

有没有办法在HANA中分割字符串？

类似于SQL Server中的等效项： SELECT * FROM dbo.fnSplitString('valueA,valueB', ',')

Answer 1

试试这个，

请参考这里

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')