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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extract date from text field 1
Excel Extract Text from decimal separated string 6
extract 3 numbers from a string 0
Trimming a dynamically changing string 2
Extracting audio from an Access Database 1
Extracting portion of a string 7
Extracting single word from string 2
Extract numbers from string 9

Back
Top