> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Text functions

> Browse Sigma text functions available in formulas and calculations.

Text functions evaluate or manipulate string data to perform operations like text modification, formatting, and extraction.

| Function                             | Description                                                                                                                                                                    |
| ------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [Concat](/docs/concat)               | Combines multiple strings into a single text value.                                                                                                                            |
| [Contains](/docs/contains)           | Searches for a specified substring in a text value. If the substring is found, the function returns `True`, otherwise it returns `False`.                                      |
| [EndsWith](/docs/endswith)           | 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](/docs/find)                   | Returns the index where it first finds the specified substring within a string. Returns `0` if not found.                                                                      |
| [ILike](/docs/ilike)                 | Returns `True` if the string matches the pattern. Case insensitive.                                                                                                            |
| [Left](/docs/left)                   | Returns the left portion of the string (the beginning), up to specified number of characters.                                                                                  |
| [Len](/docs/len)                     | Returns the number of characters in a string, including spaces.                                                                                                                |
| [Like](/docs/like)                   | Returns `True` if the string value matches the pattern. Case sensitive.                                                                                                        |
| [LPad](/docs/lpad)                   | 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](/docs/lower)                 | Converts a string to all lower case.                                                                                                                                           |
| [LTrim](/docs/ltrim)                 | Removes leading spaces from a string.                                                                                                                                          |
| [MD5](/docs/md5)                     | Calculates the hash value of a string for the [MD5](https://en.wikipedia.org/wiki/MD5) message-digest algorithm (hashing function).                                            |
| [Mid](/docs/mid)                     | Returns a substring from a string, defined by offset and length. Same as [Substring](/docs/substring).                                                                         |
| [Proper](/docs/proper)               | Converts text to proper case, capitalizing the first letter of each word.                                                                                                      |
| [RegexpCount](/docs/regexpcount)     | Returns the number of times a regular expression pattern is matched in a string.                                                                                               |
| [RegexpExtract](/docs/regexpextract) | Returns the substring that matches a regular expression within a string.                                                                                                       |
| [RegexpMatch](/docs/regexpmatch)     | Returns `True` if a string matches a regular expression.                                                                                                                       |
| [RegexpReplace](/docs/regexpreplace) | Returns a string for a pattern and replaces it with a specified string.                                                                                                        |
| [Repeat](/docs/repeat)               | Returns the result of repeating the string a specified number of times.                                                                                                        |
| [Replace](/docs/replace)             | Replaces every instance of a specified string with a replacement string.                                                                                                       |
| [Reverse](/docs/reverse)             | Reverses the order of characters in a string.                                                                                                                                  |
| [Right](/docs/right)                 | Returns the right portion of a string (the end), up to the specified number of characters.                                                                                     |
| [RPad](/docs/rpad)                   | 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](/docs/rtrim)                 | Removes trailing spaces from the end of a string.                                                                                                                              |
| [SHA256](/docs/sha256)               | Transforms text input into a 256-bit hash value.                                                                                                                               |
| [SplitPart](/docs/splitpart)         | 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](/docs/startswith)       | Determines if a string starts with the specified substring. Returns `True` or `False`.                                                                                         |
| [Substring](/docs/substring)         | Returns a substring from a string, defined by offset and length. Same as [Mid](/docs/mid).                                                                                     |
| [Trim](/docs/trim)                   | Removes both leading and trailing spaces from a string.                                                                                                                        |
| [Upper](/docs/upper)                 | Converts a string to upper case (all capital letters).                                                                                                                         |
| [UrlPart](/docs/urlpart)             | Extracts a component from a URL.                                                                                                                                               |