Text Functions
In the Calculation Editor pane, when Text is the calculation type, you can do one of the following to display a list of functions that can be performed on text fields.
• Click Text Functions.
• Right-click in the field where you enter the equation and select Insert Text Function.
In the calculation, any text function that you insert appears in red. You must insert the data field on which to perform the text function within the parentheses. After you place the mouse cursor within the parenthesis, you can use the Insert Field window to insert the appropriate data field. For more information, see Data Fields. A data field always appears in blue.
Additional information about text functions appears in the following topics:
You can use calculated result fields in text calculations. You can also use the date and math functions available for number calculations in text calculations. For more information, see: