title: How to remove special characters in XML through ESQL
body: <p>I am having problem with special characters coming in input XML.
  How can we remove the bad characters which can come anywhere in the XML field through ESQL code in broker toolkit.
  In the below XML, description field is having bad character  â€” :</p>
  
  <pre><code>&lt;notificationsRequest&gt;
    &lt;BillingCity&gt;Troutdale&lt;/BillingCity&gt;
    &lt;BillingCountry&gt;United States&lt;/BillingCountry&gt;
    &lt;BillingPostalCode&gt;97060&lt;/BillingPostalCode&gt;
    &lt;BillingState&gt;Oregon&lt;/BillingState&gt;
    &lt;BillingStreet&gt;450 NW 257th Way, Suite 400&lt;/BillingStreet&gt;
    &lt;CreatedById&gt;005w0000003QlXtAAK&lt;/CreatedById&gt;
    &lt;Type&gt;Prospect&lt;/Type&gt;
    &lt;Tyco_Operating_Co__c&gt;Tyco IS - Commercial&lt;/Tyco_Operating_Co__c&gt;
    &lt;Doing_Business_As_DBA__c&gt;Columbia Gorge Outlets&lt;/Doing_Business_As_DBA__c&gt;
    &lt;Description&gt;As of January 2016â€”the property title should read Austell    Columbia Gorge Equities, LLC-dba Columbia Gorge Outlets---so the title should be Austell Columbia Gorge Equities, LLC.&lt;/Description&gt;
  &lt;/notificationsRequest&gt;
  </code></pre>