title: Using regexp_replace in update
body: <p>I have a db column report_name which will have values similar to this</p>
  
  <pre><code>000007091_PaymentRegisterReport _D x3A 975844_2012-12-26.XLS
  </code></pre>
  
  <p>I need to delete the space before _D in all PaymentRegisterReport with XLS extension.
  Could somebody help me with the regex to use inside regexp_replace function in the update statement?</p>