TRANSLATE

TRANSLATE(char,from,to)

Returns char with all characters in from replaced with the corresponding ones in to.

  • If the number of characters in to is a multiple of the number of characters in from, that multiple of characters in to replaces each single character in from.
  • If to is empty, all characters found in from are deleted.