title: Hive - Use of replace or regexp_replace function for multiple replace conditions
body: <p>I am using Hive and trying to clean up data that may have multiple unwanted data. Would like to know if I can use a single regexp_replace  or translate function for multiple conditions.</p>
  
  <p>For Eg. If the string is <code>2000 Helen St - DO NOT USE</code> 
  I need to replace/trim <code>- DO NOT USE</code> and also change <code>St</code> to <code>Street</code>. 
  The output should be <code>2000 Helen Street</code>.</p>
  
  <p>Similarly</p>
  
  <ul>
  <li><code>3000 Cross St</code> should be <code>3000 Cross Street</code>,</li>
  <li><code>4000 Mascot Dr</code> should be <code>4000 Mascot Drive</code></li>
  <li>etc.. </li>
  </ul>
  
  <p>There are about 10 or more such clean up conditions, and the input string could either meet 0 or multiple conditions criteria. Can these conditions be set up in a single <code>regexp_replace</code>?</p>