DSXchange

Posted: **Mon Aug 24, 2009 3:05 am**

Hi,

I have got some aplhanumeric values like 9125a, 9625aa. Now I need to convert the 'a's into 0. So, it should be like 91250, 962500. Plz give some hint how to do it in transformer.

Regards,
Arnie.

Posted: **Mon Aug 24, 2009 3:30 am**

Read the column as varchar then

Code: Select all

If IsNull(columnname) then @NULL Else If Num(columnname)=0 Then Convert('a','0',columnname) Else columnname

DSXchange

Alphanumeric/Transformer

Alphanumeric/Transformer