1. Calculation functions
  2. All Functions
  3. Text functions

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.