Symptom
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
7878459NBVI need a formula field to just have this:
56342
322145
7878459As 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?
Resolution
Keywords
forum thread, forum, CR, numbervar, characters , KBA , BI-DEV , Business Intelligence Software Development Kits (SDKs) , How To