HELP?!

S

sconley

I have a column of diagnosis codesstored as text without the ".", for
example, 03100, 1560, 95202, V08, etc.
I need another column of the same codes with the ".", 031.00, 156.0, 952.02,
V08.
Is there anyway that I can put the "." back in?
 
J

J_Goddard via AccessMonster.com

If the "." is always after the third character in the text (as your examples
seem to indicate), you could use something like this:

newtext = left(oldtext,3) & "." & mid(oldtext,4).

This will work for strings less that 4 characters as well.

However, if the "." is not in the same place each time, i.e. after the third
character, I doubt you can do what you want to do, unless you have some way
of knowing where the "." should be.

John
 
S

sconley

The "." is always after the third character. The lenght of the string can be
between 3 and 5 characters.
 
R

Ron2006

The "." is always after the third character.  The lenght of the string can be
between 3 and 5 characters.









- Show quoted text -
Click to expand...

John's solution should work just fine.
 
Top