Join array with semicolon as seperator

How can i join array with semicolon as seperator?
Example : [a,b,c] became “a;b;c” string

Try the Join() function.

1 Like

The problem is that you cannot type a semicolon into the formula editor. It automatically changes it into the delimiter for the function parameters instead of seeing it as the text you want to use between the delimiters. How do we “escape” that character so that the function sees it as text?

I figured out that if you copy/paste a semicolon character into the formula builder it does not interpret it as a delimiter, unlike if you directly type that character into the builder, so that method can be used to solve such issues.

7 Likes

Thanks Benderguy. Was about to pull out my hair.