How to extract number part from a string field

[CVR]

Folks,
I need some here here.... I have one data column 'help_info" containing values like "Loan no: 12345", "Loan no:23456 part payment"

Now, I have to get the number part from these fields into separate field and display it.

I can get the number parts using java script, but in cognos 8.3 I don't know how to populate a field with output of java script.

(or)
is there a direct way (function call) to get number part from a string part so that I can apply it and get required info from data item itself..

Thanks in advance for any sort of help here.

[Gopinath]

Try some logics using functions like Position(), Substring(), and Trim()

[CVR]

All these functions need static text ... I need to find numbers like '%[0-9]%'  (pattern) in the string and extract them out...

Thanks.