SPLIT function question

Tags: #<Tag:0x00007f249e49a308>

Hello!
Could you help me, please with SPLIT() function syntaxis?

I see SPLIT(Text, Delimiter, [Split_by_each], [Remove_empty_text]) in documentation.
But when I use this format it doesn’t work or I do something wrong.

Is this the correct syntax? Should the text be in quotes? Can you send me a syntax example, please?

Hi @iryna.biletchenko

Thank you for pointing that out. Actually there is a little confusion in the documentation between how the function is described and how it actually works. I asked one of our developers to describe it better:

SPLIT(Text, Index) - divides the provided text using space character as a separator and returns the substring at zero-based position specified by the second argument.
E.g.:

  • SPLIT(“Lorem ipsum dolor”, 0) -> “Lorem”
  • SPLIT(“Lorem ipsum dolor”, 1) -> “ipsum”
  • SPLIT(“Lorem ipsum dolor”, 2) -> “dolor”
  • SPLIT(“Lorem ipsum dolor”, 3) -> #VALUE