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" <fiaola@mail.com> wrote in message 
news:eXm39F4YIHA.5028@TK2MSFTNGP04.phx.gbl...
> 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?

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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

"Dirk Goldgar" <dg@NOdataSPAMgnostics.com.invalid> wrote in message 
news:A9F8EB60-5E1A-41B4-B48C-AE6F3F614697@microsoft.com...
> "fiaola" <fiaola@mail.com> wrote in message 
> news:eXm39F4YIHA.5028@TK2MSFTNGP04.phx.gbl...
>> 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?
>
> -- 
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
> 

On Wed, 30 Jan 2008 11:44:43 -1100, fiaola wrote:

> Numbers are NOT consistent.   123ABC456DEF, ABC123DEF456, etc.
> 
> "Dirk Goldgar" <dg@NOdataSPAMgnostics.com.invalid> wrote in message 
> news:A9F8EB60-5E1A-41B4-B48C-AE6F3F614697@microsoft.com...
>> "fiaola" <fiaola@mail.com> wrote in message 
>> news:eXm39F4YIHA.5028@TK2MSFTNGP04.phx.gbl...
>>> 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?
>>
>> -- 
>> Dirk Goldgar, MS Access MVP
>> www.datagnostics.com
>>
>> (please reply to the newsgroup)
>>

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?

-- 
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Wed, 30 Jan 2008 11:44:43 -1100, "fiaola" <fiaola@mail.com> wrote:

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

"fiaola" <fiaola@mail.com> wrote in message 
news:eXm39F4YIHA.5028@TK2MSFTNGP04.phx.gbl...
> 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" <fiaola@mail.com> wrote in message 
news:eXm39F4YIHA.5028@TK2MSFTNGP04.phx.gbl...
> 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.
>