Text Equation Examples

Listed below are several examples of text equations demonstrating text functions in action.

CHAR

The CHAR function generates a character from a numeric value. The result is going to be based on the corresponding character of the numeric input read as an int ASCII code. The input should be a value from 0-255. For a character guide, please click here.

Below is a sample equation using the CHAR function.

Below are the results of this sample equation using the CHAR function.

CONCAT

The CONCAT function concatenates the given comma-separated inputs. This function requires at least one value, however, two or more should be present for there to a difference between the input and the produced value.

There are two main types of use cases for this function:

1. Input with a single field combined with static text (CONCAT: Use Case 1)
2. Input with multiple fields combined with static text (CONCAT: Use Case 2)

CONCAT: Use Case 1

Below is a sample equation using the CONCAT function with a single field combined with static text. 

Taking a closer look at this sample equation, we can see that (a) is the field and (b) is the static text. When adding text into your function, ensure that it is within single quotes.

Below are the results of this sample equation using the CONCAT function with a single field combined with static text. 

CONCAT: Use Case 2

Below is a sample equation using the CONCAT function with multiple fields combined with static text. 

Taking a closer look at this sample equation, we can see that (a) and (c) are the fields and (b) is the static text. This example shows the use of CHAR to place a space between the two fields. No more than 254 total fields and static text instances can be used within the CONCAT function.

Below are the results of this sample equation using the CONCAT function with multiple fields combined with static text. 

 

LOWER

The LOWER function generates the lowercase representation of your given values. The expected input for this function is a single field.

Below is a sample equation using the LOWER function.

Below are the results of this sample equation using the LOWER function.

 

UPPER

The UPPER function generates the uppercase representation of your given values. The expected input for this function is a single field.

Below is a sample equation using the UPPER function.

Below are the results of this sample equation using the UPPER function.

 

REVERSE

The REVERSE function generates the reverse representation of your given values. The expected input for this function is a single field. 

Below is a sample equation using the REVERSE function.

Below are the results of this sample equation using the REVERSE function.

 

LENGTH

The LENGTH function generates a numeric representation of the number of characters in your given values. The expected input for this function is a single field. 

Below is a sample equation using the LENGTH function.

Below are the results of this sample equation using the LENGTH function.

 

REPLACE

The REPLACE function replaces a defined set of characters with another defined set of characters within your given values.

The REPLACE function expects three values as input. Referencing the image below, (a) is the field that will display the replacement of value (b) to value (c), (b) is the text to replace, and (c) is the text that will replace the prior (b) value. You may use fields for values B and C or custom text. Custom text must be enclosed within single quotations (') and all values must be separated with a comma. As a reminder, the entire formula must be enclosed within the function parentheses.

For instance, say you have a Sales Rep field and you would like to replace every entry of "Edward" with "Eddie". You can accomplish this with a REPLACE function as illustrated above.

The result of this equation will appear as such:

At this time, the REPLACE function can only be used within field values that do not contain spaces.