Regular Expression

This article provides information on the following topics:

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

What is the Regular Expression Action?

The Regular Expression Action runs a regular expression on a value. This is an advanced Action designed for programmers familiar with using regular expressions.

Note: A regular expression is a sequence of characters that define a search pattern.  There are many online resources available that explain how to write a regular expression including:
RegExr - http://www.RegExr.com
Regular Expressions 101 - http://regex101.com

Creating a Regular Expression Action

Select the Advanced Action group, then select the Regular Expression Action to display the Action Builder.

Specify the Value to be parsed with a regular expression.

Enter the Expression to be used to parse the value.

Select the method:

  • Match
  • Replace
  • If Match is selected, you must select your sub method:
  • All matches
  • First match
  • Last match
  • Match Count
  • Exact Count

If Replace is selected, specify what to replace all matches with.

Select whether to save the output to:

  • List
  • Variable

If List is selected, you must enter the name of the list to create.

If Variable is selected, you must specify where the results should be stored.

Optionally add Notes to the Action to document any special instructions or functionality. When the Run Switch is set to Run, the action will be executed after clicking OK.

Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run.  For more information, see Action Builder.

Click the OK button to save the Action.