How to convert alphanumeric to a number

[Former Member]

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

[Former Member]

I dont think that there is any such function module in SAP, probably u need to read the data charcter by character and check if there is any non numeric value.

[Former Member]

check the below FM....

FIEB_EXTRACT_MINUS_NUMBERS

FIEB_EXTRACT_NUMBERS

[Former Member]

You can use REGEX.

Check this thread:

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