Supported Excel Functions
Text functions
Syntax
CONCATENATE(text1, [text2], ...)
text1 Required.
The first item to join. The item can be a text value, or a number.
text2,... Optional.
Additional text items to join.
Concatenates the text strings.
This is the Adaptive Calculation Engine implementation of the Excel CONCATENATE function.
Syntax
CONCAT(text1, [text2], ...)
text1 Required.
The first item to join. The item can be a text value, a number or a table array name.
text2,... Optional.
Additional text items to join.
Concatenates the text from multiple compute field ranges and/or strings.
This is the Adaptive Calculation Engine implementation of the Excel CONCAT function.
Syntax
EXACT(text1, text2)
text1 Required.
The first text string.
text2 Required.
The second text string.
Compares two text strings and returns true if they are exactly the same, false otherwise. EXACT is case-sensitive but ignores formatting differences.
This is the Adaptive Calculation Engine implementation of the Excel EXACT function.
Syntax
FIND(find_text, within_text, start_num)
find_text Required.
The text you want to find.
within_text Required.
The text containing the text you want to find.
start_num Optional.
Specifies the character at which to start the search. The first character in the within_text is the character number 1. If you omit the start_num, it is assumed to be 1.
Locates one text string within a second text string, and returns the number of the starting position of the first text string from the first character of the second text string.
This is the Adaptive Calculation Engine implementation of the Excel FIND function.
Syntax
SEARCH(find_text, within_text, start_num)
find_text Required.
The text you want to find.
within_text Required.
The text containing the text you want to find.
start_num Optional.
Specifies the character at which to start the search. The first character in the within_text is the character number 1. If you omit the start_num, it is assumed to be 1.
Locates one text string within a second text string, and returns the number of the starting position of the first text string from the first character of the second text string. SEARCH is case insensitive and you can use the wildcard characters: the question mark (?) and asterisk (*) in the find_text argument.
This is the Adaptive Calculation Engine implementation of the Excel SEARCH function.
Syntax
RIGHT(text1, num_chars)
text Required.
The text string containing the characters you want to extract.
num_chars Required.
Specifies the number of characters you want RIGHT to extract.
Returns the last character or characters in a text string, based on the number of characters you specify.
This is the Adaptive Calculation Engine implementation of the Excel RIGHT function.
Syntax
LEFT(text1, num_chars)
text Required.
The text string containing the characters you want to extract.
num_chars Required.
Specifies the number of characters you want LEFT to extract.
Returns the first character or characters in a text string, based on the number of characters you specify.
This is the Adaptive Calculation Engine implementation of the Excel LEFT function.
Syntax
TRIM(text)
text Required.The text string containing the characters you want to extract.
Removes all spaces (only space characters) from text except for single spaces between words.
This is the Adaptive Calculation Engine implementation of theExcel TRIM function.
Syntax
MID(text, start_num, num_char)
text Required.
The text string containing the characters you want to extract.
start_num Requiredl.
The position of the first character you want to extract in a text string. The first character in a text string has the start_num 1, and so on.
num_chars Required.
Specifies the number of characters you want MID to return from text.
Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
This is the Adaptive Calculation Engine implementation of the Excel MID function.
Syntax
LEN(text)
text Required.
The text string.
Returns the number of characters in a text string.
This is the Adaptive Calculation Engine implementation of the Excel LEN function.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
delimiter Required.
A text value or a number. If a number is supplied, it will be treated as text.
ignore_empty Required.
If true, ignore empty fields or empty table array elements.
text1 Required.
The first item to join. The item can be a text value, a number or a table array name.
text2,... Optional.
Additional text items to join.
Concatenates the text from multiple compute field ranges and/or strings, and includes a delimiter you specify between each text value that will be concatenated.
This is the Adaptive Calculation Engine implementation of the Excel TEXTJOIN function.
Syntax
SUBSTITUTE(text, old_text, new_text, start_num)
find_text Required.
The text for which you want to substitute characters.
old_text Required.
The text you want to replace.
new_text Required.
The text you want to replace old_text with.
instance_num Optional.
Optional. Specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.
Substitutes old_text for new_text in a text string.
This is the Adaptive Calculation Engine implementation of the Excel SUBSTITUTE function.