SAP Knowledge Base Article - Public

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

Resolution

Please refer to the following forum thread: Removing alpha characters from a string field

Keywords

forum thread, forum, CR, numbervar, characters , KBA , BI-DEV , Business Intelligence Software Development Kits (SDKs) , How To

Product

SAP Crystal Reports XI R2