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?
Read more...
Product
Keywords
function, formula, numvar, code, alphas, trim, CR , KBA , BI-DEV , Business Intelligence Software Development Kits (SDKs) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.