TRANSLATE : SUBSTITUTES ONE CHARACTER/BIT WITH ANOTHER
SYNTAX: TRANSLATE(X,Y,Z)
X = SOURCE STRING
Y = REPLACEMENT STRING
Z = POSITION STRING
EX: TRANSLATE(X, Y, Z);
X= '1GOLDEN'
Y='ABCSILVER'
Z='WXYGOLDEN'
NOW FOR EACH CHARACTER OF X, A SEARCH OF Z IS MADE AND IF MATCH IS FOUND THE CORRESPONDING POSITIONAL CHARACTER IN Y IS RETURNED.
SO AFTER EXECUTING TRANSLATE(X,Y,Z), THE X BECOMES '1SILVER'
