String results to convert to numeric values

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

 

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

 

[JenISCM]

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

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

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.