- Overview
- OrgData (Desktop)
-
OrgTools (Cloud)
- Quick Start
- Getting Started
- Using OrgTools
- Environment Hub
- Data Templates
- Data Backup & Restore
- Tasks
- Organization Settings
- Regular Expressions
- Troubleshooting Failed Records
Regular Expressions
The following features in OrgTools allow you to use regular expression in order to pattern match and substitute values.
- External IDs
- Data Mask
- Data Translations
Regular expressions are patterns applied to strings to match character combinations. This is used to apply actions to data.
For example, you may want to change all of user email addresses in your data set’s suffix from .source to .destination. To do so, you would apply the following RegEx pattern to the data set below and use “destination” as the substitution.
Original Data Set
john@yourorg.com.source, james@yourorg.com.source, jane@yourorg.com.source
Applied RegEx
(.)@(.) or (\d{3})[^0-9]*(\d{2})[^0-9]*(\d{4})
Resulting Data Set
john@yourorg.com.destination, james@yourorg.com.destination, jane@yourorg.com.destination
To help you construct your regular expression, see MDN’s Regular Expressions for a detailed guide on how to create regular expressions. Additionally, RegEx Tester is a useful tool to test the RegEx you have created.