Salesforce Advanced Administrator Certification Guide

REGEX

The REGEX function is used to trigger special checks on the format of a text value, using regular expressions. Discussing regular expressions is outside the scope of this book (refer to https://www.regular-expressions.info/quickstart.html for a quick start on the grammar of regular expressions), but let's summarize them by saying that you can use a sequence of characters to define a rule that a string should match.

A basic regular expression could be the format of an email address, which can be (simply) written as follows:

[a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,6}

This matches the example email address, [e-mail] (letters, numbers and some special characters before the @ sign, letters, and numbers, ...