Strings
Operation | Format | Description | Example |
---|---|---|---|
Array Diff |
| Returns items from the | Example: Input: Result: Example: Input: Result: |
Array Index of |
| Returns a number based on the position specified by the separator. Returns Inputs:
| Example: Input: Result: Example: Input: Result: Example: Input: Result: |
Array Length |
| Returns the number of items in an array for a given input. An optional | Example: Input: Result: |
At Mention |
| Converts emails to a Slack "mention." Tonkean searches slack for the specified email address and returns the username that corresponds with that email address. If no value is provided for This is a special function that requires you to have a Slack instance connected to Tonkean. See Connect Communication Sources for more information. | Input: Result: |
CharAt |
| Returns the character at the specified index (zero-based). | Input: Result: |
Comment Transcript |
| Returns the comments on an item. | Input: Result: Returns the third and fourth comments on an item, separated by a comma ( |
Concatenate |
| Concatenates the string representation of all values provided. Only one input is required, but any number of additional inputs can be provided. | Input: Result: |
Conditional Value |
| Compares a variable to a set of condition-result pairs and returns the corresponding result when the variable matches a condition (also known as a "switch" function). If the variable does not match any of the conditions, the default value is returned. | Input: Result: If |
Convert to Array |
| Converts a comma-separated list of values to an array. | Input: Result: |
Convert to String |
| Converts a specified value to a string. | Input: Result: |
Create List |
| Converts a series of values into a comma-separated list. | Input: Result: |
Day of Week |
| Returns the day of the week for a specified date and time zone. | Input: Result: |
Decimal Format |
| Concatenates a string of text and a number from two separate columns. The first variable must be a string and the second variable must be a number. | Input: Result: |
Decode from Base64 |
| Decodes a specified Base64-encoded string, converting it into its native format. | Input: Result: |
Decode HTML URL |
| Decodes an HTML-encoded string by removing special characters and numbers to make it human-readable. | Input: Result: |
Encode/Decode URL |
| Converts a human-readable URL into application/x-www-form-urlencoded format. Decode URL does the opposite: takes an application-formatted URL and turns it into a human-readable URL. | Input: Result: |
Encode to Base64 |
| Encodes a specified string into Base64 format. | Input: Result: |
Escape JSON |
| Escapes special characters in a JSON-formatted string. The following characters are escaped:
| Input: Result: |
Fallback |
| Returns the input if not empty or null, otherwise returns the fallback value. | Input: Result: |
Find Words |
| Extracts a string between specified | Example: The last portion of a receipt reads: "Total Amount: $3,644.25 Thank You for your business!" Input: Result: |
Format Full Name |
| Reformats input to a standard full name format (that is, "First Last"). | Input: Result: |
Generate Unique ID |
| Generates a unique 16-digit number or 36-character string (UUID). There are two valid inputs: | Example: Input: Result: Example: Input: Result: |
Greedy HTML Path |
| Returns all of the elements of given DOM traversal or CSS selectors from HTML. | Input: Result: |
HMAC SHA-256 Encryption |
| Encrypts an input value using hash-based message authentication code (HMAC) with hash function SHA-256. This formula is used as a means to authenticate with some APIs that require creating a hash-based signature. This formula requires two parameters:
The encrypted output is a hexidecimal string. | Input: Result: |
HTML Path |
| Returns the first match of the specified element of given DOM traversal or CSS selectors from HTML. | Input: Result: |
JSON Path |
| Returns the value of a given JSON path from the provided JSON content. The third parameter, | Example: Input: Result: Example: Input: JsonPath("{"ids":[1,2,3,4]}", "$.ids", "False") Result: |
Map |
| Maps each item in the JSON array using the specified mapping configuration—usually a formula or other operation you want to perform on the values in the array. There are two preset values you can use with this formula:
| Input: Result: |
Month |
| Returns the month for a specified date and time zone. | Input: Result: |
OCR Output Contains Words |
| Checks whether an OCR output contains the specified words. Note: Dependent on the correctness of the OCR output. | Input: Result: |
Pairs |
| Generates key-value pairs in JSON format. Include additional key and value pairs, separated by commas, to generate multiple pairs. | Input: Result: |
Previous Value |
| Returns the previous value for the specified field. Tonkean keeps track of previous values for all fields. With each change, this formula returns the most recent value. | — |
Regex Find |
| Finds the requested group of data in the custom ReGex criteria and displays the results. It’s important to know ReGex formatting in order to properly utilize this function. Visit RegEx for more information. | Input: Result: |
Replace |
| Replaces all occurrences of the {FIND} value with the {REPLACE} value within the {INPUT}. | Input: Result: |
Split Text and Take |
| Splits the input text into multiple parts as specified by the | Example: Input: Result: Example: Input: Result: |
Starts With |
| Checks whether the | Input: Result: |
String Join |
| Concatenates two specified values with a comma separating each value. | Input: Result: |
String Lookup Table |
| Retrieves specified values from a table and replaces a string with those values. | Input: Result: |
Strip HTML |
| Returns the raw text of a given HTML or CSS code snippet. All HTML/CSS tags are removed and the output will be comma- delineated. | Input: Result: |
Substring |
| Extracts a subsection of the | Input: Result: |
Take Not Empty |
| Extracts the first not-empty value from a list of values. | Input: Result: |
Text Analysis |
| Compares a variable to a set of expression-result pairs and returns the corresponding result when the variable matches an expression (also known as a "switch" function). If the variable does not match any of the expressions, the default value is returned. | Input: Result: |
To Lower Case |
| Converts a specified string to lowercase text. | Input: Result: |
To Pascal Case |
| Converts a specified string to Pascal case, where the first letter of each word is capitalized. | Input: Result: |
To Upper Case |
| Converts a specified string to UPPERCASE text. | Input: Result: |
Trim |
| Removes the spaces before and after a provided string. | Input: Result: |