in formula html how to escape characters

AI generated answer (using internal Slack threads):

In NetSuite's Advanced HTML/PDF templates, you can use the

?html

built-in to escape HTML special characters. For example,

${item.name?html}

. This will escape any HTML special characters in the

item.name

string. For escaping characters in a formula, you can use the

REPLACE

function. For example,

REPLACE(ns_concat({memberitem.name}), ',', '<br>')

will replace each comma in the concatenated member item names with a line break. If you need to include an apostrophe in a formula, you can escape it by using two single quotes. For example,

WHEN {name}='Prince''s'

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******