Text & patterns Scalar

translate()

Replaces each character in string that matches a character in the from set with the corresponding character in the to set. If from is longer than to, occurrences of the extra characters in from are deleted

Arguments & returns

`translate(string, from, to)`

Scalar

Overload link	`string`	`from`	`to`	Returns
#01	`VARCHAR`	`VARCHAR`	`VARCHAR`	`VARCHAR`

Example

SELECT translate('12345', '143', 'ax');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3