I need to trim a string. What I need to trim off is anything following the first number(s)
1 black cat jumped false true 1
12 red cat sat true false 2
123 Yellow dog sat true false 2
So all I want is the 1, 12 or 123.
How do I go about doing this. So basically anything following the first number. I can't set a length for the number becasue it is incremented based on the number of entries the user adds on another form.