Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Built-in Functions _ Get Only Numeric Values From String

Posted by: LagoDavid Jul 22 2019, 09:46 AM

Can someone help me write a function that would take a string input and return only the numeric characters as an integer? The string will have from 3 to 7 alphabetic characters followed by 1-15 numeric characters. I want to strip out the numeric characters and return them as an Integer value.

Posted by: theDBguy Jul 22 2019, 09:48 AM

Hi. Perhaps you could start with this one from the Wiki and just modify it to fit your needs: https://www.UtterAccess.com/wiki/GetDigitsOnly

Posted by: LagoDavid Jul 22 2019, 11:27 AM

PERFECT!!
Thank you so much. With easy modifications works exactly as I needed.

Posted by: theDBguy Jul 22 2019, 11:30 AM

Hi. You're welcome. Good luck with your project.