title: Regexp substr starting position in different strings in PL\SQL
body: <p>I have strings like these:</p>
  
  <pre><code>16.09.D 25435 11141 Joseph Martin Smith 3333 Kairo 
  
  Bristol 2223 Anna Franklin
  
  Soul 23333333 Henry Bayes
  </code></pre>
  
  <p>I want to get just the names from these strings. The fix thing is the names are always after the numbers, but as you can see, in the first string, there are numbers after the name John Smith.
  My code is now:</p>
  
  <pre><code>regexp_substr(string, '([0-9]+ )([^0-9]+\D)', 1, 1, 'i', 2))
  </code></pre>
  
  <p>The problem is, from the first string, I get the name, but there will be a <code>whitespace</code> character after that. How can I get just the name from the first string, without any <code>whitespaces</code> after it?</p>