String Functions

btrim()

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

UQL
return btrim("  Ultipa Graph   ") AS newString

Result:

UQL
return btrim("123ABC341", "123") AS newString

Result:

endsWith()

Checks whether a string ends with a specified substring, returning 1 for true and 0 for false.

UQL
return endsWith("ultipa.com", "com")

Result:

length()

Returns the number of characters in a string.

UQL
return length("Ultipa Graph")

Result:

lower()

Converts all the characters in a given string to lowercase.

UQL
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.

UQL
return ltrim("  Ultipa Graph   ") AS newString

Result:

UQL
return ltrim("124ABC341", "123") AS newString

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.

UQL
return rtrim("  Ultipa Graph   ") AS newString

Result:

UQL
return rtrim("123ABC4321", "123") AS newString

Result:

split()

Splits a string into a list of substrings using the specified delimiter.

UQL
return split("apple, pumpkin, lemon tart", ", ") as strList

Result:

startsWith()

Checks whether a string begins with a specified substring and returns 1 for true or 0 for false.

UQL
return startsWith("ultipa.com", "ultipa")

Result:

upper()

Converts all the characters in a given string to uppercase.

UQL
return upper("Ultipa Graph")

Result: