title: hive regexp_replace remove multiple strings
body: <p>In my data i have strings that have special characters </p>
  
  <pre><code>&amp;#39, &amp;amp; &amp;quot, 
  </code></pre>
  
  <p>is there a way to use regexp_replace to replace multiple strings. Even better is there a way to select 'test_column' and if there are weird characters(etc. &amp;) to remove them. In my query i am using</p>
  
  <pre><code>select regexp_replace(test_column, "(&amp;#39)|(&amp;amp;)","'| &amp;") as my_column
  </code></pre>
  
  <p>This is not doing what i intend it to do. everywhere it finds the weird characters it replaces it with </p>
  
  <pre><code>'|&amp;
  </code></pre>
  
  <p>Is there a way to catch and change all of these using a select statement or how can i correctly use regexp_replace on multiple strings.</p>