TRANSLATE

Replaces characters in a string based on a character mapping.

Analyze Syntax

func.translate(<str>, <from>, <to>)

Analyze Examples

func.translate('hello', 'el', 'ip')

┌─────────┐
 'hippo'  
└─────────┘

SQL Syntax

TRANSLATE(<str>, <from>, <to>)

SQL Examples

SELECT TRANSLATE('hello', 'el', 'ip');

┌───────┐
 hippo  
└───────┘