extracting numbers from a string

F

fiaola

Hello,

I'm trying to extract numbers from a string stored in an Acces table field.
What is the best method to do this or the correct function to use?

Thanks.
 
D

Dirk Goldgar

fiaola said:
Hello,

I'm trying to extract numbers from a string stored in an Acces table
field. What is the best method to do this or the correct function to use?
Click to expand...

That will depend on how the numbers are stored in the string, and to what
extent the string format is consistent. What do your field values look
like?
 
F

fredg

Numbers are NOT consistent. 123ABC456DEF, ABC123DEF456, etc.
Click to expand...

So in your first example your numbers are 123456.
How do you wish to display them?
As 123456 or as 123 456 etc., or how?
 
J

John W. Vinson

Numbers are NOT consistent. 123ABC456DEF, ABC123DEF456, etc.
Click to expand...

What result would you desire from these strings? 123456? An array of numbers,
123, 456? Six digits, 1, 2, 3, 4, 5, 6?

John W. Vinson [MVP]
 
T

thomaszheng

fiaola said:
Hello,

I'm trying to extract numbers from a string stored in an Acces table
field. What is the best method to do this or the correct function to use?

Thanks.
Click to expand...
 
T

thomaszheng

fiaola said:
Hello,

I'm trying to extract numbers from a string stored in an Acces table
field. What is the best method to do this or the correct function to use?

Thanks.
Click to expand...
 
Top