Workflow Template Bug, Converting Symbol To Decimal Code

[Jordan_Davis1]

I have a workflow template that sends a PDF and for some reason it’s converting the © symbol to the decimal code ©

I tried wrapping it in TEXT but that didn’t work. Should I be encoding this in something or is this a bug?

[Steve]

Please post a screenshot of the relevant portion of your template.

[Jordan_Davis1]

The workflow template column provides a link to the copyright website or, if blank, it provides a link to the Spotify page with the text of the record label the represents the recording (the ‘P Line’).

if the P Line has a copyright symbol © it comes out like this:

[Steve]

Hmmm… I’d call that a bug, myself: HYPERLINK() should not be encoding the clickable text.

You’ll probably have to work around this, perhaps by using SUBSTITUTE() to replace © with (c).

[Jordan_Davis1]

Sounds good. Thanks, Steve.