title: How to choice specific range ( using redshift regex )
body: <p>I'm trying a regular expression to extract only numbers between letters or special characters.</p>
  
  <p>I have an amazon-redshift environment and am using the regexp_substr function to solve the problem, but it doesn't work so well.</p>
  
  <p>My table</p>
  
  <pre><code>+------------------------+
   |    text                |
   +------------------------+
   | abc:1+550(name)        |
   | abc:1+1100(name)       |
   | abc:1+512(name)        |
   | abc:1+2932(name)       |
   +------------------------+
  </code></pre>
  
  <p>My code
  regexp_substr(a.text,'^+[\d]($')  &lt;- but, not work.</p>
  
  <p>I've never learned regular expressions properly and I can't solve it myself by referring to the related documents.</p>
  
  <p>Expected table</p>
  
  <pre><code>+------------------------+
   |    text                |
   +------------------------+
   | 550                    |
   | 1100                   |
   | 512                    |
   | 2932                   |
   +------------------------+
  </code></pre>