How can I parse this string?

I have a few hundred records that look like this

mcnn 123030040506
mcas sa 123033
mscc 223449
mcnn sa 1000300300


What I need is the NUMBER part of the string, which, as you can see, the lenght is not always the same, BUT is always separated by an empty space from the rest and always on the right side.

Important: I need to use the query builder.

thanks in advance!!

re: How can I parse this string?

InStrRev() will locate the position of the last space in the string and you can then use Right() and Len() to parse out the characters beyond this final space.
Welcome to Bytes!

Linq ;0)>

re: How can I parse this string?

re: How can I parse this string?

I always forget that Mid() doesn't require that third argument, and that if you omit it it returns everything until the end of the string.

Linq ;0)>

re: How can I parse this string?

great! thanks for the suggestions