String results to convert to numeric values

J

JenISCM

A table containing data from an imported surce, gives me a text string result
similar to this example:

001002003004005006007008009010011012101102103104105106107108109110111112201202203204205206207208209210211212

(My actual string has 36, three-digit values that can range from 0-999. 108
digits total)

What formula can I use in a query to get the individual values of each of
the three digit numbers.
EX: 1, 2, 3, 4, 5, 6 ... 101, 102, 103, `104, 105, 106, ... 201, 202, 203,
204, 205

Any Assistance is greatly appreciated.
 
J

John Spencer

I see no easy way to do this. The expression you would need would be
something like:

Field: N1: Val( Mid([thestring],(1*3)-2,3))
Field: N2: Val(Mid([TheString],(2*3)-2,3))
....
Field: N36: Val(Mid([TheString],(36*3)-2,3)

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
J

JenISCM

Thank you very much - that worked perfectly!!
--
JenISCM


John Spencer said:
I see no easy way to do this. The expression you would need would be
something like:

Field: N1: Val( Mid([thestring],(1*3)-2,3))
Field: N2: Val(Mid([TheString],(2*3)-2,3))
....
Field: N36: Val(Mid([TheString],(36*3)-2,3)

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

JenISCM said:
A table containing data from an imported surce, gives me a text string
result
similar to this example:

001002003004005006007008009010011012101102103104105106107108109110111112201202203204205206207208209210211212

(My actual string has 36, three-digit values that can range from 0-999.
108
digits total)

What formula can I use in a query to get the individual values of each of
the three digit numbers.
EX: 1, 2, 3, 4, 5, 6 ... 101, 102, 103, `104, 105, 106, ... 201, 202,
203,
204, 205

Any Assistance is greatly appreciated.
 

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


Top