Savant

Returns the first non-null value from a list of options.

COALESCE

Concatenates multiple text strings into a single string

CONCAT

Checks if text contains specified subtext.

CONTAINS

Returns the first non-empty value from a list of options.

FIRST_NOT_EMPTY

Computes the hash value of a text using a specified algorithm (MD5 or SHA-1)

HASH

Escapes HTML special characters in a text string

HTML_ESCAPE

IS_EMPTY

JSON_FIELD

Sets a value for a specific field in JSON data

JSON_SET

Retrieves the leftmost characters from a text string.

LEFT_PART

Computes the length (number of characters) of a text string

LENGTH

Measures the edit distance (Levenshtein distance) between two text strings

LEVENSHTEIN

Converts text to all lowercase characters

LOWER

Pads the left-side of text with a specified character to ensure a minimum text length

PAD_LEFT

Pads the right-side of text with a specified character to ensure a minimum text length

PAD_RIGHT

Capitalizes the first letter of each word in a text string

PROPER

Extracts text that matches a regular expression pattern

REGEX_EXTRACT

Checks if a text string matches a specified regular expression pattern

REGEX_MATCH

Replaces text that matches a regular expression pattern with a specified replacement

REGEX_REPLACE

Returns the index of the first character of the first matching substring based on a regular expression pattern

REGEX_SEARCH

Repeats a specified string a given number of times.

REPEAT()

Replaces all occurrences of a specified search string with a replacement string

REPLACE

Reverses the order of characters in a text string

REVERSE

Retrieves the rightmost characters from a text string.

RIGHT_PART

Searches for a specific search string within a text and returns the index of the first occurrence

SEARCH

Converts text to a SOUNDEX code for phonetic matching

SOUNDEX

Extracts a specific part of a text string using a delimiter

SPLIT_PART

Converts HTML escape sequences in text back to their original characters

UNESCAPE_HTML

Converts text to all uppercase characters

UPPER

Text

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you