title: remove all numbers after space in a dataset
body: <p>I have been learning regexp_replace to clean up my dataset and have come across a new problem.</p>
  <p>I have a dataset that looks like this:</p>
  <p>$14..89<br />
  30 0<br />
  40 -<br />
  56 e<br />
  37.5<br />
  0.25<br />
  16.8.9</p>
  <p>I want the data set to look like this:<br />
  14.89<br />
  30<br />
  40<br />
  56<br />
  37.5<br />
  0.25<br />
  16.89</p>
  <p>I have used the following codes:</p>
  <pre><code>SELECT CAST(REGEXP_REPLACE('30 0', '(\.)\.+|[^0-9.]', '\1\2\3') AS DECIMAL(16,2)) from dual;
  </code></pre>
  <p>the problem with the first code is, although it works on the other numbers, it turns 30 0 into 300, when it should be 30</p>
  <pre><code>SELECT CAST(REGEXP_REPLACE('.25', '(\.)\.+|[^0-9]|(\w+).*$', '\1\2\3') AS DECIMAL(16,2)) from dual;
  
  SELECT CAST(REGEXP_REPLACE('.25 0', '(\.)\.+|[^0-9]|(^.*?)(\w+).*$', '\1\2\3') AS DECIMAL(16,2)) from dual;
  </code></pre>
  <p>the problem with the two codes at the top is, even though it turns 30 0 into 30 (which is what I want), it messes up the other numbers.</p>
  <p>If someone could help me solve this issue so that I can get all the numbers to look the way it is in the second list, that would be great. Thank you</p>