Ask the Community
Groups
How to remove the HTML tags seen in the export of a BMS Report. - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>Question: </strong>When exporting a report to PDF or Excel, the notes field contains the HTML formatting tags. (e.g., <p>, $nbsp;). How do I remove these?</p> <p><strong>Answer: </strong>You can make use of the<strong> #StripHTMLTags </strong>function. For example, if this is for Account ID or Client, this would be the function:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0"><em>StripHtmlTags(HTMLDecode({Activities.AccountID)</em></pre> <p><img src="/attachments/token/nfpXM9LER2hYJXqtB7E7KFgmG/?name=html.png" alt="https://kaseya.zendesk.com/attachments/token/nfpXM9LER2hYJXqtB7E7KFgmG/?name=html.png" class="embedImage-img importedEmbed-img"></img><br><strong>Note: </strong><em>StripHtmlTags(HTMLDecode({Tickets.Details}))</em> for Ticket Details.</p> <p>If you do not find the <strong>StripHtmlTags</strong> in the Exago formula list, manually entering them will also work.</p> </article> </main>