extract only the numeric element of a text string.

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

Hi, Is it possible to extract only the numeric element of a text string.

i.e. 123 Somewhere Avenue, thanks, Garry
 
If the numbers are always in the beginning of the string as in your example,
use the Val function.

Val("123 Somewhere Avenue") returns 123
 
Hi,



If the number is at the start, then val( ) would do:

? val("123 kjlk")
123



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract a text between two last parentheses 3
Functions 2
Extract Numbers from text and numeric string 3
Excel Extract Text from decimal separated string 6
EXTRACT DATA FROM FIELD 3
Extracting the numbers from the Text Field 13
How to extract numeric portion of alphanumeric data 9
extracting the n-th element of a string 1

Back
Top