extracting numbers from a string

[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.

 

[Dirk Goldgar]

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?

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?

 

[fiaola]

Numbers are NOT consistent. 123ABC456DEF, ABC123DEF456, etc.

 

[fredg]

Numbers are NOT consistent. 123ABC456DEF, ABC123DEF456, etc.

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?

 

[John W. Vinson]

Numbers are NOT consistent. 123ABC456DEF, ABC123DEF456, etc.

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]

 

[thomaszheng]

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.

 

[thomaszheng]

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.