Categories:: String & Binary Functions (General)

TRANSLATE¶

Translates subject from the characters in sourceAlphabet to the characters in targetAlphabet.

Syntax¶

TRANSLATE( <subject>, <sourceAlphabet>, <targetAlphabet> )

Arguments¶

subject: A string expression that is translated. If a character in subject is not contained in sourceAlphabet, the character is added to the result without any translation.
sourceAlphabet: A string with all characters that are modified by this function. Each character is either translated to the corresponding character in the targetAlphabet or omitted in the result if the targetAlphabet has no corresponding character (i.e. has less characters than the sourceAlphabet).
targetAlphabet: A string with all characters that are used to replace characters from the sourceAlphabet.

Collation Details¶

Arguments with collation specifications are currently not supported.

Examples¶

Translate ‘X’ to ‘c’, ‘Y’ to ‘e’, ‘Z’ to ‘f’ and remove ‘❄’ characters:

SELECT TRANSLATE('❄a❄bX❄dYZ❄','XYZ❄','cef');

--------------------------------------+
 TRANSLATE('❄A❄BX❄DYZ❄','XYZ❄','CEF') |
--------------------------------------+
 abcdef                               |
--------------------------------------+