Hello all,
The problem is when I integrate multi-selection question with Google sheet, the selections were passed with a comma delimiter without escape / parentheses. I am trying to split them up and place them into an array in Integromat.
Example:
Select:
- Answer A with comma, and a “double quote”
- Answer B with comma, and a “double quote”
- Answer C with comma, and a “double quote”
The result is pass into a Google cell like this:
Answer A with comma, and a “double quote”, Answer B with comma, and a “double quote”, Answer C with comma, and a “double quote”
I can’t easily split it up. It would be nice if it has some escape characters or parentheses.
I am trying to pass the answers in an array form on Integromat but couldn’t do it if I cannot split it up cleanly. Ideally ending up something like:
[“Answer A with comma, and a \“double quote\””, “Answer B with comma, and a \“double quote\””, “Answer C with comma, and a \“double quote\””]
Any suggestions?
Many thanks!
