String Help

S

scott

I have a string like 1.0.1 that I need to increase the last digit to 1.0.2
for example.

How can I isolate the last digit after the 2nd period in a string like
"1.0.1"?
 
K

kingston via AccessMonster.com

eval(mid(string,instr(instr(1,string,".")+1,string,".")+1) + 1)
 
J

John Vinson

I have a string like 1.0.1 that I need to increase the last digit to 1.0.2
for example.

How can I isolate the last digit after the 2nd period in a string like
"1.0.1"?
Click to expand...

I presume you would also want 3.24.109 to increment to 3.24.110?

Note that you may want to consider using three Integer fields rather
than one composite text field.

John W. Vinson[MVP]
 
Top