本文介绍了HANA:字符串分割了吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否可以在HANA中拆分字符串?
Is there a way to split a string in HANA?
类似于SQL Server中的等效内容:SELECT * FROM dbo.fnSplitString('valueA,valueB', ',')
Something similar to the equivalent in SQL Server: SELECT * FROM dbo.fnSplitString('valueA,valueB', ',')
推荐答案
尝试一下,
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')
这篇关于HANA:字符串分割了吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!