Syntax

    Arguments

    — 分隔符是一个字符串，是用来分割的标志字符. 类型: String

    s — 需要分割的字符串. 类型: String

    Returned value(s)

    需要分割的字符串的首尾是分隔符;

    多个分隔符连续出现;

    Type: Array(String)

    仅支持向量化引擎中使用

    1. select split_by_string('a1b1c1d','1');
    2. +---------------------------------+
    3. | split_by_string('a1b1c1d', '1') |
    4. +---------------------------------+
    5. | ['a', 'b', 'c', 'd']            |
    6. +---------------------------------+
    8. select split_by_string(',,a,b,c,',',');
    9. +----------------------------------+
    10. | split_by_string(',,a,b,c,', ',') |
    11. | ['', '', 'a', 'b', 'c', '']      |
    14. SELECT split_by_string(NULL,',');
    15. +----------------------------+
    16. | split_by_string(NULL, ',') |
    17. +----------------------------+
    18. | NULL                       |
    19. +----------------------------+
    21. select split_by_string('a,b,c,abcde',',');
    22. +-------------------------------------+
    23. | split_by_string('a,b,c,abcde', ',') |
    24. +-------------------------------------+
    25. | ['a', 'b', 'c', 'abcde']            |
    26. +-------------------------------------+
    28. +---------------------------------------------+
    30. +---------------------------------------------+
    31. | ['1', '2,3', '4,5', 'abcde']                |
    32. +---------------------------------------------+
    34. select split_by_string(',,,,',',,');
    35. +-------------------------------+
    36. | split_by_string(',,,,', ',,') |
    37. +-------------------------------+
    38. | ['', '', '']                  |
    39. +-------------------------------+
    41. select split_by_string(',,a,,b,,c,,',',,');
    42. +--------------------------------------+
    43. | split_by_string(',,a,,b,,c,,', ',,') |
    44. +--------------------------------------+
    45. +--------------------------------------+