1410959 - Removing alpha characters from a string field

The following issue was resolved in our Crystal Reports Design forum.

I have a string field that I'm working with, and I need to ignore the alphas (only need to look at the numbers). The field looks like the following:

THREE EXAMPLES:

56342PL
322145B
7878459NBV

I need a formula field to just have this:

56342
322145
7878459

As you can see, there's no set length to the numbers or the alphas. I'm hoping that there's a simple crystal function that will just look at the numbers and ignore the alphas? Some sort of Trim derivative?

function, formula, numvar, code, alphas, trim, CR , KBA , BI-DEV , Business Intelligence Software Development Kits (SDKs) , How To