Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to convert alphanumeric to a number

Dear SDNers,

Thanks for reading my post.

I have an alpha numeric field, which I need to clean up and only keep the numeric part (i'm not interested in any of the characters within that field).

As an example, if the fiedl contains A12B34C - then I only need the 1234 part. Ofcourse if it contained spaces, special characters like &,(,* etc then they should be ignored as well.

I was wondering if there is a function within SAP that does this automatically.

Many thanks for your help

Tags:
replied

You can use REGEX.

Check this thread:

https://forums.sdn.sap.com/click.jspa?searchID=17015755&messageID=5584549

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question