title: sql split and replace string in table
body: <p>I have data in table as below and trying to use Replace to do it, but I am ending up with either double semicolon ';;; or semicolon at end after using replace. Can I use split and replace to achieve this or any other ways??</p>
  
  <pre><code>    Test attempts;My attempts using operation;Additions, deletions, and modifications 
      Test attempts;My attempts using operation
      Test attempts;access to information;attempts using nex;Additions, deletions, and modifications
      Test attempts;Changes to programs
  </code></pre>
  
  <p><strong>Replace 'My attempts using operation' with emptystring AND
      Replace 'attempts using nex' with 'attempts using imex' in above data column</strong></p>
  
  <pre><code>    Result should be:
  
      Test attempts;Additions, deletions, and modifications 
      Test attempts-- No semicolon should be there if it ends up at end with that after replace
      Test attempts;access to information;attempts using imex;Additions, deletions, and modifications
  
  Test attempts;Changes to programs
  </code></pre>