TRANSLATE

Transforms a given string by replacing specific characters with corresponding replacements, as defined by the provided mapping.

Syntax

TRANSLATE('<inputString>', '<charactersToReplace>', '<replacementCharacters>')

Examples

-- Replace 'd' with '$' in 'datalake'
SELECT TRANSLATE('datalake', 'd', '$');

---
$atalake

-- Replace 'd' with 'D' in 'datalake'
SELECT TRANSLATE('datalake', 'd', 'D');

---
Datalake

-- Replace 'd' with 'D' and 'e' with 'E' in 'datalake'
SELECT TRANSLATE('datalake', 'de', 'DE');

---
DatalakE

-- Remove 'd' from 'datalake'
SELECT TRANSLATE('datalake', 'd', '');

---
atalake