extracting numbers from a string

  • Thread starter Thread starter fiaola
  • Start date Start date
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.
 
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?
 
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?
 
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]
 
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...
 
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...
 
Back
Top