extract only the numeric element of a text string.

G

Garry

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

i.e. 123 Somewhere Avenue, thanks, Garry
 
J

Jerry Whittle

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
 
M

Michel Walsh

Hi,



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

? val("123 kjlk")
123



Hoping it may help,
Vanderghast, Access MVP
 
Top