title: Return a digit in the middle of a string regex
body: <p>I'm not sure how to do a regexp_replace to return a digit in the middle of the string.</p>
  <p>My current string is : &quot;Game of Thrones S2 Ep6&quot; and I need to return the Season number from this. My current regex does the job correctly but takes two regexp expressions:</p>
  <pre><code>REGEXP_REPLACE(REGEXP_REPLACE('Game of Thrones S1 Ep12', r'(^[^_]*\sS)', ''), r'(\s*Ep\s*\d*\s*$)', '')
  </code></pre>
  <p>Some other test entries are:</p>
  <blockquote>
  <p>&quot;Smallville S 10 Ep 12&quot;</p>
  <p>&quot;The Days of Our Lives S26 Ep324&quot;</p>
  </blockquote>
  <p>This first Strips off the text up to and including the first &quot; S&quot;.
  Then splits off the end of the string up to and including the whitespace before &quot;Ep&quot;</p>
  <p>Can someone please give me a capture group that allows this to be done in one replace. This is a very costly query at the moment.</p>