Learn more about text functions CONCATENATE, JOIN, MATCH, FIND, FIRST, LAST, LENGTH, UPPERCASE, LOWERCASE, CAPITALIZE, TRIM, INDEXOF, LASTINDEXOF, SUBSTRING, SUBSTRING BEFORE, SUBSTRING AFTER, SPLIT, REPLACE, EQUALS.
Overview
| Function | Description |
|---|
| CONCATENATE | Use the '+' (plus) operator to concatenate strings or a combination of strings and other type values to produce a single string value. |
JOIN | Joins a series of values into one string, separated with a character of your choice. |
| MATCH | Compares a string pattern to another string and returns TRUE if the string exactly matches the pattern, and otherwise FALSE. The MATCH function is case-sensitive. |
| FIND | Looks for a string pattern within another string and returns the first matching characters. The function is case-sensitive. |
| FIRST | Returns the first character(s) of a string, based on the number of characters you specify. |
| LAST | Returns the last character(s) of a string, based on the number of characters you specify. |
| LENGTH | Returns the length of a string. |
| UPPERCASE | Returns a string with all characters in uppercase. |
| LOWERCASE | Returns a string with all characters in lowercase. |
| CAPITALIZE | Returns a string with the first character uppercased. |
| TRIM | Strips the leading and trailing spaces from a string. |
| INDEXOF | Returns the index of the first occurrence of a specified substring in a string. |
| LASTINDEXOF | Returns the index of the last occurrence of a specified substring in a string. |
| SUBSTRING | Returns the substring of a given string starting from the index provided and ending at the end index if provided, or the end of the string. |
| SUBSTRING BEFORE | Returns the start of a given string before the first occurrence of substring, or an empty string if substring is not found. |
| SUBSTRING AFTER | Returns the end of a given string after the first occurrence of substring, or an empty string if substring is not found. |
| SPLIT | Returns a multivalued string attribute containing every substring that is delimited by the given pattern. |
| REPLACE | Replaces every occurrence of a string pattern within another string with a provided replacement string. The function is case-sensitive. |
| EQUALS | Compares two strings and returns TRUE if and only if they are equal. This function is case sensitive. |
Go here for more info on the Text Substitution Language (TSL) documentation.
| Include Page |
|---|
| Text function CONCATENATE |
|---|
| Text function CONCATENATE |
|---|
|
| Include Page |
|---|
| Text function JOIN |
|---|
| Text function JOIN |
|---|
|
| Include Page |
|---|
| Text function MATCH |
|---|
| Text function MATCH |
|---|
|
| Include Page |
|---|
| Text function FIND |
|---|
| Text function FIND |
|---|
|
| Include Page |
|---|
| Text function FIRST |
|---|
| Text function FIRST |
|---|
|
| Include Page |
|---|
| Text function LAST |
|---|
| Text function LAST |
|---|
|
| Include Page |
|---|
| Text function LENGTH |
|---|
| Text function LENGTH |
|---|
|
| Include Page |
|---|
| Text function UPPERCASE |
|---|
| Text function UPPERCASE |
|---|
|
| Include Page |
|---|
| Text function LOWERCASE |
|---|
| Text function LOWERCASE |
|---|
|
| Include Page |
|---|
| Text function CAPITALIZE |
|---|
| Text function CAPITALIZE |
|---|
|
| Include Page |
|---|
| Text function TRIM |
|---|
| Text function TRIM |
|---|
|
| Include Page |
|---|
| Text function INDEXOF |
|---|
| Text function INDEXOF |
|---|
|
| Include Page |
|---|
| Text function LASTINDEXOF |
|---|
| Text function LASTINDEXOF |
|---|
|
| Include Page |
|---|
| Text function SUBSTRING |
|---|
| Text function SUBSTRING |
|---|
|
| Include Page |
|---|
| Text function SUBSTRING BEFORE |
|---|
| Text function SUBSTRING BEFORE |
|---|
|
| Include Page |
|---|
| Text function SUBSTRING AFTER |
|---|
| Text function SUBSTRING AFTER |
|---|
|
| Include Page |
|---|
| Text function SPLIT |
|---|
| Text function SPLIT |
|---|
|
| Include Page |
|---|
| Text function REPLACE |
|---|
| Text function REPLACE |
|---|
|
| Include Page |
|---|
| Text function EQUALS |
|---|
| Text function EQUALS |
|---|
|