String Functions

btrim()

Removes characters from both ends of a given string until encountering a character that is not contained in the specified set of characters.

RETURN btrim("  Ultipa Graph   ") AS newString

Result:

RETURN btrim("123ABC341", "123") AS newString

Result:

char_length()

Returns the number of characters in a string.

character_length() is a synonym to char_length().

RETURN char_length("Ultipa Graph")

Result:

left()

Returns a substring of the given string containing the specified number of leftmost characters.

RETURN left("Ultipa Graph", 6)

Result:

lower()

Converts all the characters in a given string to lowercase.

RETURN lower("Ultipa Graph")

Result:

ltrim()

Removes characters from the begining of a given string until encountering a character that is not contained in the specified set of characters.

RETURN ltrim("  Ultipa Graph   ") AS newString

Result:

RETURN ltrim("124ABC341", "123") AS newString

Result:

normalize()

Converts a string into a consistent format based on the normalization form specified, in accordance with Unicode Standard Annex #15.

This function is typically used to compare two strings by their Unicode codepoints. Two characters appear identical to human eyes may have different codepoints, such as the multiplication sign × (U+00D7) and the letter x (U+0078).

RETURN normalize('×') = normalize('x') AS result

Result:

replace()

Returns a string where all occurrences of a specified substring are replaced with another string.

RETURN replace("hello world", "world", "graph") AS result

Result:

right()

Returns a substring of the given string containing the specified number of rightmost characters.

RETURN right("Ultipa Graph", 5)

Result:

rtrim()

Removes characters from the end of a given string until encountering a character that is not contained in the specified set of characters.

RETURN rtrim("  Ultipa Graph   ") AS newString

Result:

RETURN rtrim("123ABC4321", "123") AS newString

Result:

split()

Returns a list of string resulting from the splitting of the given string around matches of the given delimiter.

RETURN split("apple,banana,grape", ",")

Result:

RETURN split("[email protected]", "@")[0] AS username

Result:

substring()

Returns a substring of a given length from the given string, beginning with a 0-based index start.

RETURN substring("crystal hawk river", 0, 7) AS subText

Result:

trim()

Removes all the occurrences of the specified single character from either the leftmost, rightmost, or both ends of a given string.

RETURN trim("  Ultipa Graph   ") AS newString

Result:

RETURN trim(BOTH "a" FROM "aaGraph DBa") AS newString

Result:

RETURN trim(LEADING "a" FROM "aaGraph DBa") AS newString

Result:

RETURN trim(TRAILING FROM "  Graph DB   ") AS newString

Result:

upper()

Converts all the characters in a given string to uppercase.

RETURN upper("Ultipa Graph")

Result: