title: How to extract the number(0-9) from the string in informatica?
body: <p>I want to extract the number(0-9) from the string. e.g.</p>
  
  <ol>
  <li>if src is <code>*J$456*&amp;56</code> then tgt should be <code>45656</code>         </li>
  <li>if src is <code>&amp;*(&gt;123&gt;&gt;789&amp;^</code> then tgt should be <code>123789</code></li>
  </ol>
  
  <p>This is just an example, special characters or alphabets are random in string, so how to extract only numbers?</p>
  
  <p>Thanks is advance.</p>
  
  <p>Regards
  sheetal</p>