Using ; separator in split function

How To
1

Hi, so im trying to convert the string “Value1;Value2;Value3” to an array with the split function but im unable to escape the ; character. I can’t change the string because it comes like that from the source. Whenever I put ; , Make things its a parameter separator and not the value im choosing to separate the values.

How can I make this work?

2

Just copy paste the semicolon from somewhere else, instead of typing in the formula section and it should work after that.

2 Likes
3

Omg, thank you! Never thought of that.

1 Like