10-02-2008 5:09 PM
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
10-02-2008 5:19 PM
You can use REGEX.
Check this thread:
https://forums.sdn.sap.com/click.jspa?searchID=17015755&messageID=5584549
10-02-2008 5:17 PM
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.
10-02-2008 5:18 PM
check the below FM....
FIEB_EXTRACT_MINUS_NUMBERS
FIEB_EXTRACT_NUMBERS
10-02-2008 5:19 PM
You can use REGEX.
Check this thread:
https://forums.sdn.sap.com/click.jspa?searchID=17015755&messageID=5584549