Savant

Concatenates multiple text strings into a single string

CONCAT

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

Retrieves the leftmost characters from a text string

LEFT_SUBSTR

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

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

Extracts the rightmost characters of a text string up to a specified length

RIGHT_SUBSTR

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

Extracts a portion of a text string starting from a specified position with a given length

SUBSTRING

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