translate

In a given string, replaces the occurrence of any of the characters of a second given string with the corresponding characters of a third given string or removes the occurrence of characters of a second given string if no corresponding character exists in the third given string.

Syntax

    translate(string, string, string)

Parameters

Three string values separated by commas. The first string is the string in which characters are replaced. The second string contains the characters whose occurrences in the first string are replaced. The third string contains the replacement characters that correspond with the characters in the second string.

The characters in the second string correspond with the characters in the third string that have the same index:

  • If the second string is longer than the third string, the characters in the second string that have an index that is greater than the length of the third string have no corresponding characters.

  • If the third string is longer than the second string, the characters in the third string that have an index that is greater than the length of the second string are ignored.

  • If a character occurs more than once in the second string, the first occurrence of the character determines how that character is replaced in the first string.

Returns

A string that contains the first parameter with the replaced characters.

Example

The following expression includes a second parameter that includes characters that all correspond with a character in the third parameter. The expression returns BAr:

translate("bar","abc","ABC")

The following expression includes a second parameter that is longer than the third parameter. The expression returns AAA:

translate("--aaa--","abc-","ABC")

The following expression includes a second parameter that includes multiple occurrences of a character. The expression returns BAr:

translate("bar", "aba", "ABC")