UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Get Only Numeric Values From String, Access 2016    
 
   
LagoDavid
post Jul 22 2019, 09:46 AM
Post#1



Posts: 551
Joined: 12-October 03
From: Texas


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.
Go to the top of the page
 
theDBguy
post Jul 22 2019, 09:48 AM
Post#2


Access Wiki and Forums Moderator
Posts: 76,414
Joined: 19-June 07
From: SunnySandyEggo


Hi. Perhaps you could start with this one from the Wiki and just modify it to fit your needs: GetDigitsOnly()

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
LagoDavid
post Jul 22 2019, 11:27 AM
Post#3



Posts: 551
Joined: 12-October 03
From: Texas


PERFECT!!
Thank you so much. With easy modifications works exactly as I needed.
Go to the top of the page
 
theDBguy
post Jul 22 2019, 11:30 AM
Post#4


Access Wiki and Forums Moderator
Posts: 76,414
Joined: 19-June 07
From: SunnySandyEggo


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

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st October 2019 - 12:36 PM