split_by_string

description

Syntax

ARRAY<STRING> split_by_string(STRING s, STRING separator)

Splits a string into substrings separated by a string. It uses a constant string separator of multiple characters as the separator. If the string separator is empty, it will split the string s into an array of single characters.

Arguments

separator — The separator. Type: String

s — The string to split. Type: String

Returned value(s)

Returns an array of selected substrings. Empty substrings may be selected when:

A non-empty separator occurs at the beginning or end of the string;

There are multiple consecutive separators;

The original string s is empty.

Type: Array(String)

example

  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. +----------------------------------+
  12. | ['', '', 'a', 'b', 'c', '']      |
  13. +----------------------------------+
  15. SELECT split_by_string(NULL,',');
  16. +----------------------------+
  17. | split_by_string(NULL, ',') |
  18. +----------------------------+
  19. | NULL                       |
  20. +----------------------------+
  22. select split_by_string('a,b,c,abcde',',');
  23. +-------------------------------------+
  24. | split_by_string('a,b,c,abcde', ',') |
  25. +-------------------------------------+
  26. | ['a', 'b', 'c', 'abcde']            |
  27. +-------------------------------------+
  29. select split_by_string('1,,2,3,,4,5,,abcde', ',,');
  30. +---------------------------------------------+
  31. | split_by_string('1,,2,3,,4,5,,abcde', ',,') |
  32. +---------------------------------------------+
  33. | ['1', '2,3', '4,5', 'abcde']                |
  34. +---------------------------------------------+
  36. select split_by_string(',,,,',',,');
  37. +-------------------------------+
  38. | split_by_string(',,,,', ',,') |
  39. +-------------------------------+
  40. | ['', '', '']                  |
  41. +-------------------------------+
  43. select split_by_string(',,a,,b,,c,,',',,');
  44. +--------------------------------------+
  45. | split_by_string(',,a,,b,,c,,', ',,') |
  46. +--------------------------------------+
  47. | ['', 'a', 'b', 'c', '']              |
  48. +--------------------------------------+

keywords

SPLIT_BY_STRING,SPLIT