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.