How to count at character number?

[paispatin]

Dear all,

I have this one :

A1="A9906001"
It mean : (A9906=front code) (001= count number)

How to make count number is counting 1 by 1?
What I need is :
A2="A9906002"
A3="A9906003"

I already make this program:

a="A9906001"
b=RIGHT(a,3)
c=LEFT(a,5)

so I got b="001", now how do I count b so it become something like this :
b=b+1 ==> 001+1=002 ==> b="002"
or
b=b+2 ==> 001+1=003 ==> b="003"
and than join with this program :

newnumber=c+b && for "A9906002"


I think VFP 8 have functions to solve my problem but I still don't know yet.

Thank you in advance

 

[Stefan5627]

paispatin,

you can use this code:

b = padl( transform( val(b)+1 ), 3, '0' )

hth,

Stefan

 

[paispatin]

Yes Stefan, that's what I need.
Thank you very much.