changing format

[arnie_nits]

Hi I have a requirement where
A1 will become A001
A13 will become A013

Please suggest how to get this.

Regards,

[anbu]

If you always have only one alphabet and followed by any number of digits then try this

Code: Select all

svAlpha=input_field[1,1]
svNum=input_field[2]
target_field=svAlpha : right('000':svNum,3)

[ArndW]

NewColumn = in.Field[1,1]:FMT(In.Field[2,99],"3'0'R")

[arnie_nits]

Thanks...it works....

Regards,
Arnie.