extract only the numeric element of a text string.

Thread view:

Thread rating:

Garry - 28 Mar 2006 14:30 GMT

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

i.e. 123 Somewhere Avenue, thanks, Garry

Jerry Whittle - 28 Mar 2006 15:14 GMT

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

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi, Is it possible to extract only the numeric element of a text string.
>
> i.e. 123 Somewhere Avenue, thanks, Garry

Michel Walsh - 28 Mar 2006 15:14 GMT

Hi,

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

? val("123 kjlk")
123

Hoping it may help,
Vanderghast, Access MVP

> Hi, Is it possible to extract only the numeric element of a text string.
>
> i.e. 123 Somewhere Avenue, thanks, Garry