String Functions | Tableau CRM SAQL Developer Guide

ascii()
Returns the UTF-8 code value of a character n.

chr()
Returns the UTF-8 character of integer n.

ends_with()
Returns true if the string ends with the specified characters.

index_of()
Returns the location (index) of the specified characters.

len()
Returns the number of characters in the string.

lower()
Returns a copy of the string with all characters in lower case.

ltrim()
Removes the specified characters from the beginning of a string.

mv_to_string()
Converts multivalue fields to string fields.

number_to_string
Converts a number literal to a string literal.

replace()
Replaces a substring with the specified characters.

rtrim()
Removes the specified characters from the end of a string.

starts_with()
Returns true if the string starts with the specified characters.

string_to_number
Converts a string literal to a number literal.

substr()
Returns a substring that starts at the specified position. You can also specify the length of the substring to return.

trim()
Removes the specified substring from the beginning and the end of a string.

upper()
Returns a copy of the string with all characters in upper case.