15.9.15 translate(expression, from_string, to_string)

Function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time.

Vallue1: exp - A text expression in which you want to replace characters. Value can be one of the following types: text.

Value2: from_string - A text expression that is the characters you want to replace. Value can be one of the following types: text.

Value3: to_string - A text expression that is the characters that you want to use for replacement in the order of from_string. When you include fewer characters in this argument than are in from_string, the function removes the extra characters in from_string from the return value. Value can be one of the following types: text.

Returned value type will be text.

Function Result

translate(client_name, "JONES", "Mark"), where the value for client_name is Cooper JONES.

Cooper Mark