numeric

[yucatan]

Hello Guys,

I have a number like this: JY0001

i wanne do the number +1

so that JY0001

become: JY0002

i'm a bit confused and i dont know how to do this?

Thanks

[Melba23]

yucatan,

Use StringMid to split the string into the alpha and numeric parts - convert the numeric part into numeric type with Number - add 1 to it - reconvert to string with the correct format using StringFormat - reform the string:

$sInput = "JY0001"

$sAlpha = StringMid($sInput, 1, 2)
$sNumeric = StringMid($sInput, 3)

$sNumeric = StringFormat("%04i", Number($sNumeric) + 1)

$sOutput = $sAlpha & $sNumeric

MsgBox(0, "Result", $sOutput)

M23

[yucatan]

yucatan,

Use StringMid to split the string into the alpha and numeric parts - convert the numeric part into numeric type with Number - add 1 to it - reconvert to string with the correct format using StringFormat - reform the string:

$sInput = "JY0001"

$sAlpha = StringMid($sInput, 1, 2)
$sNumeric = StringMid($sInput, 3)

$sNumeric = StringFormat("%04i", Number($sNumeric) + 1)

$sOutput = $sAlpha & $sNumeric

MsgBox(0, "Result", $sOutput)

M23

Thanks alot!!!!