Find number in a string

[MVChowdary]

Hello,
Below is the example code to get the number from string.

Code:

l_String="The number of players was 86 and..."
l_num=""
    For i=1 to len(l_String)
            y=mid(l_String,i,1)
                If ( isnumeric(y)=True) Then
                          l_num= l_num & y
                End If
    Next
    msgbox l_num