How to replace binary Number to 9

[neha_gupta]

Hi 

My data set values are 

Numbers

1101

1001

0000

1000

0101

1010

And i want to replace the '0' with 3 and '1' with 2 .

How can we do that?

Thanks in advance.

[Kurt_Bremser · Accepted solution]

Convert to character with the put() function, use the translate() function to do the replacements, and convert back to numeric by using the input() function.

[neha_gupta]

Thanks mate,

Yes Its working fine.