Token Functions
This feature lets you edit the token value with one or more pre-configured operations.
| Name | Description |
|---|---|
| Average | Replaces a token with the average of the numeric values. |
| Encode URI | Converts a token's characters (except RFC 2396 unreserved characters) to the hexadecimal representation so the token can be used in a web address. For example, "http://My Website.com" is converted to "http://My%20Website.com". |
| Encode URL | Converts a token's characters (except RFC 3987 unreserved characters) to the hexadecimal representations so that the token can be used in a web address. This activity converts more characters than Encode URI does. For example, " ?parameter1=1&1parameter2=2" is converted to "%3Fparameter1%3D1%26parameter2%3D2". |
| Encode XML | Replaces a token with encoded values of XML characters. For example, "<tag>" is displayed as "<tag>". |
| Escape Search Name | Includes a backslash (\) in a query that contains an escape character. |
| Escape Search Phrase | Includes a backslash (\) in a query that contains Laserfiche search syntax and an escape character. |
| Max | Replaces a token with the largest numeric value in the token. |
| Min | Replaces a token with the smallest numeric value in the token. |
| Remove | Removes exact matches from a token value. For example, when you type "def" in the text box under the drop-down menu, and type "abcdefg" in the Test Value text box, you will still see "abcdefg" in the Result Value box. If you type "def" in the Test Value text box, the value will be removed. |
| Remove At | Removes the value at the index, where "1" is the first value in the token. |
| Remove Duplicates | Removes duplicate values from the token. |
| Remove Empty Items | Removes empty values from the token. |
| Remove Text | Removes the matched substring from the string. For example, when you type "def" in the text box under the drop-down menu, and type "abcdefg" in the Test Value text box, you will see "abcg" in the Result Value box. |
| Sort Ascending | Organizes the values in the token from smallest to largest. |
| Sort Descending | Organizes the values in the token from largest to smallest. |
| Split |
Divides a single-value token into a multi-value token based on specified characters in the token. When you apply this function, a text box appears for you to specify the characters the token will be divided at. For example, if the token's value is "Jan;Bob;Sue" and you specify ; as the delimiter, then the result of this function will be a token with three values: Jan, Bob, Sue. If the token's value is Animal Control Department Health Department Human Resources Department Accounting Department, and you specify "Department" as the delimiter, the resulting multi-value token will have four values: Animal Control, Health, Human Resources, Accounting. |
| Sum | Replaces token with the sum of the values in the token. |
| Text Length | Replaces token with the number of characters in the token. |
| To Lower | Converts all letters in the token to lowercase. |
| To Title Case |
Converts the first letter of each word in the token to uppercase. Tip: If your token is in all capital letters and you want to convert it to title case, first apply the To Lower function and then the To Title Case function. |
| To Upper | Converts all letters in a token to uppercase. |
| Trim | Removes whitespace before and after a token's value. |
| Value Count | Replaces token with the number of values in the token. |