Extracting data from alpha numeric field

[Adam]

I have a field that contains alpha numeric data. How do I
separate the alpha and numeric information from this field?

For example:
3S1W1 ------> 3 S 1 W 1
3S1W2CD ----> 3 S 1 W 2 CD
2S1W34AA ---> 2 S 1 W 34 AA

Thanks for the help!

 

[[MVP] S. Clark]

Chr$(65) = "A"

asc(0)= 48
asc(9)= 57
asc("Z")= 90
asc("A")= 65

Thus, to decipher if something is a Number or a Letter, you can check the
asc() val. If it's between 48 and 57, you have a number... 65-90 is a
letter.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-