DSXchange

Hi all,
I have requirement in which ,i need to change a alphanumeric number to 10 digit number with all the alphabets replaced to "0" including "@,&,%,/" etc and preceding zero's to make it 10 digit .

(e.g):-(1). AF001234 TO 0000001234
(2). N/A TO 0000000000
(3). 1234ERTY TO 0012340000

Can anyone give me with some ideas?

Thanks

Convert() function is perfect for this task, in both server and parallel jobs.

And then pad zeros for the parts it doesn't handle.

It won't. For starters, there's no If in the expression, even though there are Then and Else. Second, you seem to be assuming some kind of loop through the characters in the string, which does not exist.

Set a stage variable to contain all the characters that must be converted to zero, for example svZeroChars. Create another containing the number of zero characters as there are in svZeroChars, for example svZeroes. Then use Convert() to convert these to zero and any function to pad to length. For example

I tried using "Convert" functions and "Str" .It worked fine guys.Thanks you