Searching for numbers on a string

[rereis]

Hi all

Using CR 11, how do I get just the number of a field of type string that looks like:

"Your case number is 2676356 give us a call."

thanks

 

[lbass]

stringvar array x := split({table.string}," ");
numbervar i;
numbervar j := ubound(x);
numbervar y;
for i := 1 to j do(
if isnumeric(x) then
y := val(x)
);
y

This assumes one number per string.

-LB