how can i convert string to integer 1

[H2]

I have a string (eg. ABC123456CC), and wanna extract the number out (123456) and output it by adding 1 (123457)
how can i do it??

thanks
H2

 

[foxbox]

Is the number always starting at position 4, length 6?

cTest = "ABC123456CC"
nResult = Cint(mid(cTest,4,6)) + 1 br
Gerard

 

[H2]

no, it wont always be like this.
so any method to extract the number out?

thanks anyway
H2

 

[foxbox]

Than i see no alternative then to parse your string and investigate each character with IsNumeric() . . . br
Gerard

 

[H2]

thanks
it's very helpful for me.