translate

Returns "string_expression1" in which characters from "string_expression3" are translated to the equivalent characters in "string_expression2". "String_expression4" is a single character that is used to pad "string_expression2" if it is shorter than "string_expression3". If only "string_expression1" is present, then this function translates it to uppercase characters.

Syntax

translate ( string_expression1 [ , string_expression2, 
string_expression3 [ , string_expression4 ] ] )

Example 1

translate ( 'abcdefg' )

Result

Returns ABCDEFG.

Example 2

translate ( 'mnlop' , n, m , - )

Result

Returns n-nlop.