Double Quotes Handling
AnsweredI'm trying to write a custom attribute based on a custom field where a value has a double quote (") in it. I seem to have an error with this.
What should be done so that it will accept a double quote in the string?
Thanks
-
Hi Gef, I experimented and made this work by using the HTML code for a quote, " instead of the actual quote character. Here's the example attribute I used:
""Status is""+ " " +[Ticket status]+
". Ticket was created in "+ " " +[Ticket created - Year]+ "."and here is the results
-
Hiya,
Does this still work? It's not producing that result for me:
-
Hi Connor Hays, thanks for the question. I've just tested this and the quotes do work in a report if you click Chart Configuration > Chart, then set Text interpretation to "HTML"
However, unfortunately, that doesn't work for the filter values as you show in your screenshot above, only the report results themself. I hope this helps!
-
Hm, I see that now but it still doesn't solve my use case, which was to make excel hyperlinks work in the export. Not a breaking issue but it would be nice to be able to escape the quote character:
-
Attaching a more legible screenshot and tagging Rob Stack :)
-
Thanks Connor Hays, I tested this too and it seems not to be possible at this point. This is definitely worth posting in our Explore Feedback section at https://support.zendesk.com/hc/en-us/community/topics/360001200913. That way members of the product team will see it more easily and other people can vote on this request.
Sorry I wasn't able to give you the answer you wanted.
Please sign in to leave a comment.
6 Comments