Product: VDRPro
Applies to: All Manager roles, Publisher Plus
Regular expressions (often called "regex") are simple but powerful scripts that can be used to find text that match the patterns you specify. For example, you can use this regular expression to search for email addresses: ([a-zA-Z0-9_\.-]+)@([\da-zA-Z\.-]+)
You can use regex to speed document redaction. You can use regex with both AI redaction and manual redaction. Your documents will be searched for the combination of numbers and symbols that match the pattern in your expression, allowing you to find all email addresses in a single search, for example.
Disclaimer: The regex patterns provided here are suggestions only, and checking the redaction results prior to publication of any redacted document remains the sole responsibility of the document editor/publisher/redactor.
SS&C Intralinks is not responsible for the results of any regex pattern used to redact documents.
Sample patterns
Social Security Numbers/national identity numbers
Example match:
123-45-6789 (US Social Security Number)
| United States | \d{3}-\d{2}-\d{4} |
| France | \d{13}.[^a-zA-Z]\d |
| Italy | [A-Z]{2}[0-9]{5}[A-Z]{2} |
| Spain | \d{2}-\d{8} |
| United Kingdom | [A-Z]{2}[0-9]{6}[A-Z]{2} |
| Germany | [0-9]{8}[A-Z]{1}[0-9]{3} |
Phone numbers
Example matches:
555 555-1234
1 555-555-1234
| United States/Canada/Caribbean |
(\+?( |-|\.)?\d{1,2}( |-|\.)?)?(\(?\d{3}\)?|\d{3})( |-|\.)?(\d{3}( |-|\.)?\d{4}) |
| Other Countries | ((\+)[0-9]\s?).[^a-zA-Z]+|0[67](\s?\d{2}){4} |
Email addresses
Matches:
Any standard-format email address
([a-zA-Z0-9_\.-]+)@([\da-zA-Z\.-]+)\.([a-zA-Z\.]{2,6})
Dates/birthdates
| MM/DD/YYYY | ^([1][12]|[0]?[1-9])[\/-]([3][01]|[12]\d|[0]?[1-9])[\/-](\d{4}|\d{2})$ |
| DD/MM/YYYY | ([a-zA-Z0-9_\.-]+)@([\da-zA-Z\.-]+)\.([a-zA-Z\.]{2,6}) |
Passport numbers
Example matches:
1234567890ABC1234567A1234567<<<<<<<<<<<<<<12
| United States | ^[A-Z0-9<]{9}[0-9]{1}[A-Z]{3}[0-9]{7}[A-Z]{1}[0-9]{7}[A-Z0-9<]{14}[0-9]{2}$ |
| France | [0-9]{2}[A-Z]{2}[0-9]{5} |
| Italy | [A-Z]{2}[0-9]{7} |
| Spain | [A-Z]{1}[0-9]{7} |
| United Kingdom | [0-9]{10}[A-Z]{3}[0-9]{8}[A-Z]{1}[0-9]{1} |
| Germany |
Monetary amounts
Example matches:
€1234567
1234567$
([\$£€]|EUR|GBP|USD) *\d+(?:[\.,]\d+)?| *\d+(?:[\.,]\d+)+ *?([\$£€]|EUR|GBP|USD)
Bank account numbers/IBAN
Example matches:
DE89 3704 0044 0532 0130 00
AT61 1904 3002 3457 3201
FR14 2004 1010 0505 0001 3
([A-Z]{2}[0-9]{2}.+[0-9]{1,30})