Scalar FunctionsString Functions

translate

Replaces characters in a string based on character mapping.

Syntax

translate(search_list, replace_list, source)

Prop

Type

Returns: string

print translate("aei", "AEI", "raid on the monastery")

print_0 (string)
rAId on thE monAstEry

toupper

Converts a string to upper case.

trim

Removes leading and trailing match of the specified regex from the source string.