RE: Email Template – Generating Subject with an Field containing Ampersand
Hi Guys,
Have you encountered the issue, where you have an Ampersand in the field value, causing the template to be generated with the escape character “&”.
And to complicate it even further, the field is being used on the Subject part of the email, which makes it even more complicated.
Replacing the ampersand with the escape character in a field formula didn’t help.
Replacing it in the template, as NetSuite suggests, has no affects whatsoever.
Using the un_esc tag is not supported in the output_format.
Can you share where and how you are attempting to escape that character?
Also, are you using scriptable templates within SuiteScript 2.0? What’s the exact context of execution?
Hi,
It’s indeed a scriptable email template, being generated by an SS1.0 Workflow action.
For example, if one of the fields in the subject have a value such as “FP&A”, the email will be generated with an escaped character, meaning, the email will arrive as FP&A.
On Email buddy there is no such issue, because of the no_esc setting, which has no influence on the subject.
Also, doing a replace in the subject formula (replacing & with &), works only till the next edit of the template (Since the template engine replaces the & back to &).
There are workarounds, but wa just wondering if someone was able to solve it without any workaournds.
