How to convert alphanumeric to a number
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
You can use REGEX.
Check this thread: