Convert a string to json, it has a colon in the string

Hello,

I have a data > Dámy;Páni and i want to convert it to [“Dámy”,“Páni”]

I actually tryed to split by since it has a colon in between i am unable to, what would be the solution??

Thanks you

This is somehow tricky as the ; would be confused with the split function. to get this solved, you can do the following: paste this text in this format, and this will do the trick:
{{split(“Dámy;Páni”; “;”)}}

2 Likes