Analytics SAQL Developer Guide
Summer '25 (API version 64.0)
Spring '25 (API version 63.0)
Winter '25 (API version 62.0)
Summer '24 (API version 61.0)
Spring '24 (API version 60.0)
Winter '24 (API version 59.0)
Summer '23 (API version 58.0)
Spring '23 (API version 57.0)
Winter '23 (API version 56.0)
Summer '22 (API version 55.0)
Spring '22 (API version 54.0)
Winter '22 (API version 53.0)
Summer '21 (API version 52.0)
Spring '21 (API version 51.0)
Winter '21 (API version 50.0)
Summer '20 (API version 49.0)
Spring '20 (API version 48.0)
Winter '20 (API version 47.0)
Summer '19 (API version 46.0)
Spring '19 (API version 45.0)
Winter '19 (API version 44.0)
Summer '18 (API version 43.0)
Spring '18 (API version 42.0)
Winter '18 (API version 41.0)
Summer '17 (API version 40.0)
Spring '17 (API version 39.0)
Winter '17 (API version 38.0)
Summer '16 (API version 37.0)
Spring '16 (API version 36.0)
Winter '16 (API version 35.0)
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
ascii()
chr()
ends_with()
index_of()
len()
lower()
ltrim()
mv_to_string()
number_to_string
replace()
rtrim()
starts_with()
string_to_number
substr()
trim()
upper()
Windowing Functions
coalesce
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.