Use functions to build expressions that perform a variety of calculations and operations.
Types of Functions
These function types are available for transforming your data. The type of data determines the functions you can use. Visit Data Types for more information.
Conditional functions allow you to perform an action or calculation using an IF statement. Learn more in the Conditional Functions article.
Conversion functions convert numbers to strings or strings to numbers. Learn more in the Conversion Functions article.
DateTime functions allow you to perform an action or calculation on a date and time value. Learn more in the DateTime Functions article.
A file function builds file paths, checks to see if a file exists, or extracts a part of a file path. Learn more in the File Functions article.
A finance function applies financial algorithms or mathematical calculations. Learn more in the Finance Functions article.
A math function performs mathematical calculations. Learn more in the Math Functions article.
A bitwise function operates on one or more bit patterns or binary numerals at the level of their individual bits. Use a bitwise function to manipulate values for comparisons and calculations. Learn more in the Math:Bitwise Functions article.
A minimum or maximum function finds the smallest and largest value of a set of values. Learn more in the Min/Max Functions article.
An operator is a character that represents an action. Use an arithmetic operator to perform mathematical calculations or a Boolean operator to work with true/false values. Learn more in the Operators article.
A spatial function builds spatial objects, analyzes spatial data, and returns metrics from spatial fields. Learn more in the Spatial Functions article.
These functions perform a variety of specialized actions and can be used with all data types. Learn more in the Specialized Functions article.
A string function performs operations on text data. Use a string function to cleanse data, convert data to a different format or case, compute metrics about the data, or perform other manipulations. Learn more in the String Functions article.
A test function performs data comparisons. Use a test function to identify the data type of a value, or determine if a value exists. Learn more in the Test Functions article.
Functions can be built within the expression editor.
Build an Expression
To build your expression, first, specify an Output Column. The Output Column will contain the results of your expression. You can overwrite an existing column or you can create a new column. Select the Output Column dropdown and choose an existing column or select Add New and provide a name for your new column.
Once you specify an Output Column, use any of these methods to build an expression:
- Enter the function directly in the expression editor.
- Select the Columns and Constants button to browse through variables that can be used in the expression. Select the variable to add it to the expression editor.
As you edit the expression, the editor applies a color-coding scheme to its various parts to make the parts of the expression easy to distinguish. For example, functions are gold, variables are fuchsia, operators are magenta, and strings are turquoise, a blue-green.
Select Functions to browse through categories of functions. Select the function to add it to the expression editor.
Columns and Constants
Select Columns and Constants to browse data from incoming connections and global variables.
- Existing Columns: Data from an incoming connection, or from a column created in a previous expression.
- Connections from Questions: Values from an Interface tool connected to the Question anchor of a tool with an expression editor, when the tool is used in an app or macro. Use the Question anchor when you want question values to be used as variables in the expression. Visit Interface Tools for more information.
- Constants: Global variables for a workflow that make it possible to change a value in a single location and have that change apply to the rest of the workflow. Visit Constants for more information.
Recent and Saved Expressions
Select Recent and Saved Expressions to browse through recent and saved expressions. Select the expression to add it to the expression editor.
Save an Expression
- With an expression in the expression editor, select the Save Expression (disk) icon.
- Enter a name for the expression and select Save.
Tools with Expression Editor
These tools include an expression editor. Tools that use an expression editor have an additional Input anchor and Question anchor when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor when you want question values to be used as variables in the expression. Visit Interface Tools for more information.