Text functions - Anaplan Technical Documentation

Anaplan provides a range of functions that enable you to work with text.

Text-formatted values enable you to collaborate with and capture insights from people who use the models you build. Use the text functions available in Anaplan to effectively work with this data.

You can use text functions to extract strings from text, find specific characters, concatenate text values, convert values to text, and more. See the full list of text functions in the table below.

Title	Description
FIND	The FIND function searches for the first occurrence of a text value within another one. If the text contains the specified characters, the function returns a number. This number indicates the position of the first occurrence of the text value searched for.
LEFT	Extracts a string of characters from text, starting from the left.
LENGTH	The LENGTH (or LEN) function returns the number of characters in a text string.
LOWER	The LOWER function converts text values to lowercase.
MAILTO	Use the MAILTO function to generate clickable links that send an email. You can specify recipients, subjects, and body text.
MAKELINK	The MAKELINK function generates clickable links in a module.
MID	Extracts a number of characters from a text string, starting from a character you select.
NAME	Use the NAME function to convert data from a list item to text.
RIGHT	Extracts a string of characters from text, starting from the right.
SUBSTITUTE	The SUBSTITUTE function finds all occurrences of a text value within another one, and replaces them with a given value.
TEXT	The TEXT function converts numeric values to text.
TEXTLIST	The TEXTLIST function concatenates a series of text values into a single text value.
TRIM	The TRIM function removes all leading and trailing spaces, and extra spaces between words in a text string.
UPPER	The UPPER function converts text values to uppercase.