Vertica Analytics Platform Version 9.2.x Documentation

TRANSLATE

Replaces individual characters in string_to_replace with other characters.

Behavior Type

Immutable

Syntax

TRANSLATE ( string_to_replace , from_string , to_string );

Parameters

string_to_replace

String to be translated.

from_string

Contains characters that should be replaced in string_to_replace.

to_string

Any character in string_to_replace that matches a character in from_string is replaced by the corresponding character in to_string.

Example

=> SELECT TRANSLATE('straße', 'ß', 'ss');
 TRANSLATE
-----------
 strase
(1 row)