Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Built-In Functions/ String Functions/ translate
Updated on 2023-10-25 GMT+08:00
View PDF
Share

translate

This function is used to translate the input string by replacing the characters or string specified by from with the characters or string specified by to.

For example, it replaces bcd in abcde with BCD.

translate("abcde", "bcd", "BCD")

Syntax

translate(string|char|varchar input, string|char|varchar from, string|char|varchar to)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

str

Yes

STRING

String to be truncated

separator

Yes

STRING

Separator of the STRING type

count

No

INT

Position of the delimiter

Return Values

The return value is of the STRING type.

If the value of any input parameter is NULL, NULL is returned.

Example Code

The value A1B2C3 is returned.

SELECT translate('AaBbCc', 'abc', '123');
Parent topic: String Functions