# Text Functions Text functions evaluate or manipulate string data to perform operations like text modification, formatting, and extraction. | | | | ----------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [concat](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/concat "mention") | Combines multiple strings into a single text value. | | [contains](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/contains "mention") | Searches for a specified substring in a text value. If the substring is found, the function returns `True`, otherwise it returns `False`. | | [endswith](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/endswith "mention") | Determines if a text value ends with a specified substring. If the substring is found at the end of the text value, the function returns `True`, otherwise it returns `False`. | | [find](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/find "mention") | Returns the index where it first finds the specified substring within a string. Returns `0` if not found. | | [ilike](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/ilike "mention") | Returns `True` if the string matches the pattern. Case insensitive. | | [left](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/left "mention") | Returns the left portion of the string (the beginning), up to specified number of characters. | | [len](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/len "mention") | Returns the number of characters in a string, including spaces. | | [like](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/like "mention") | Returns `True` if the string value matches the pattern. Case sensitive. | | [lpad](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/lpad "mention") | Sets the string to a desired length by adding or removing characters at the front. Uses an optional fill character or defaults to extra spaces. | | [lower](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/lower "mention") | Converts a string to all lower case. | | [ltrim](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/ltrim "mention") | Removes leading spaces from a string. | | [md5](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/md5 "mention") | Calculates the hash value of a string for the [md5](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/md5 "mention") message-digest algorithm (hashing function) | | [mid](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/mid "mention") | Returns a substring from a string, defined by offset and length. Same as [substring](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/substring "mention"). | | [proper](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/proper "mention") | Converts text to proper case, capitalizing the first letter of each word. | | [regexpextract](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/regexpextract "mention") | Returns the substring that matches a regular expression within a string. | | [regexpmatch](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/regexpmatch "mention") | Returns `True` if a string matches a regular expression. | | [regexpreplace](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/regexpreplace "mention") | Returns a string for a pattern and replaces it with a specified string. | | [repeat](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/repeat "mention") | Returns the result of repeating the string a specified number of times. | | [replace](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/replace "mention") | Replaces every instance of a specified string with a replacement string. | | [reverse](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/reverse "mention") | Reverses the order of characters in a string. | | [right](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/right "mention") | Returns the right portion of a string (the end), up to the specified number of characters. | | [rpad](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/rpad "mention") | Sets the string to a desired length by adding or removing characters at the end. Uses an optional fill character, or defaults to extra spaces. | | [rtrim](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/rtrim "mention") | Removes trailing spaces from the end of a string. | | [splitpart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/splitpart "mention") | Splits the string into multiple parts at the positions of each appearance of the delimiter and returns the nth part of the string at the specified position. | | [startswith](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/startswith "mention") | Determines if a string starts with the specified substring. Returns `True` or `False`. | | [substring](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/substring "mention") | Returns a substring from a string, defined by offset and length. Same as [mid](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/mid "mention"). | | [trim](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/trim "mention") | Removes both leading and trailing spaces from a string. | | [upper](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/upper "mention") | Converts a string to upper case (all capital letters). |