title: Is there a way to find special subStrings in this case with regex?
body: <p>I have a string from which numbers are extracted at the end of the String with regex.</p>
  <p>String:</p>
  <blockquote>
  <p>'0 DB'!$B$460</p>
  </blockquote>
  <p>subString:</p>
  <blockquote>
  <p>460</p>
  </blockquote>
  <p>I solve this as follows:</p>
  <pre><code>String str = &quot;'0 DB'!$B$460&quot;;
  String sStr = str.replaceAll(&quot;.*?([0-9]+)$&quot;, &quot;$1&quot;);
  </code></pre>
  <p>Old question Link:
  <a href="https://stackoverflow.com/questions/65308815/is-there-a-way-to-find-out-how-many-numbers-are-at-the-end-of-a-string-without-k?noredirect=1#comment115459577_65308815">Is there a way to find out how many numbers are at the end of a string without knowing the exact index?</a></p>
  <p>Now I have a different kind of string from which I want to extract certain ranges.</p>
  <p>String:</p>
  <blockquote>
  <p>'0 DB'!$U$305:$AH$376</p>
  </blockquote>
  <p>Here I would extract certain areas to the left of colon and to the right of colon.</p>
  <p>Once the area between the dollar signs($), and the number after it. The respective areas can have different lengths. The part before the first dollar sign can consist of letters as well as numbers</p>
  <p>So that would be 4 substrings.</p>
  <p>subStrings:</p>
  <blockquote>
  <p>1: U</p>
  <p>2: 305</p>
  <p>3: AH</p>
  <p>4: 376</p>
  </blockquote>
  <p>I was thinking of solving this with regex as well. But unfortunately my knowledge in this regard is limited.</p>
  <p>Does anyone have an idea how I can solve this with regex? Or are there other ways?</p>
  <p>Thanks</p>