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.
MATCH, FIND, SPLIT and REPLACE use a regular expression as one of their parameters. These parameters are not intended to be filled with values that could have been typed by a user, because a user could craft a regular expression that causes unexpected behavior. |
| 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. |
| 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.