This page lists the string functions that are available in the GSQL query language.
gsql_uuid_v4()
gsql_uuid_v4()
Generates and returns a version-4 universally unique identifier(UUID).
STRING
None.
lower()
lower(str)
Returns the input string with all letters in lowercase.
STRING
trim()
trim( [ [ LEADING | TRAILING | BOTH ] [removal_char FROM] ] str )
Trims characters from the leading and/or trailing ends of a string.
By using one of the keywords LEADING
, TRAILING
, or BOTH
, the user can specify that characters are to be removed from the left end, right end, or both ends of the string, respectively. If none of these keywords is used, the function will remove from both ends.
STRING
upper()
upper(str)
Returns the input string with all letters in uppercase.
STRING
Parameter
Description
Data type
str
The string to convert to lowercase
STRING
Parameter
Description
Data type
removal_char
Optional. The character to remove. If removal_char
is not specified, the function will remove whitespaces, including spaces, tabs, and new lines. If removal_char
is specified, the user must also write the keyword FROM
between removal_char
and str
.
STRING
str
A string value.
STRING
Parameter
Description
Data type
str
The string to convert to uppercase
STRING