String Functions

Use SAQL string functions to format your measure and dimension fields.

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.