SAP Knowledge Base Article - Preview

1410959 - Removing alpha characters from a string field

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
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?


Read more...

Product

SAP BusinessObjects Business Intelligence platform all versions

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.