With Formatter, you can use the Text extract function to perform a specific search within your text and return the first match found. This is useful if you have a lot of text (such as an email) and only want to use a certain part of it (such as the sender's phone number).
1. Add the Formatter app
2. Extract Email Address
This function looks for a string of letters, numbers, and certain symbols (such as periods, plus signs, and dashes), immediately followed by an @ symbol, and then a site domain such as example.com.
- What it will find: firstname.lastname@example.org
- What it won't find: Arthur Dent AT example.com
3. Extract Number
This function looks for one or more digits in a row. It can accommodate a single period used as a decimal separator, or multiple commas for digit grouping.
- What it will find: 1,234,567 or 12.34
- What it won't find: 123-456-789
4. Extract Phone Number
This function looks for a 10-digit phone number either in groups of 3-3-4 digits, or groups of 4-3-3 digits, with an optional country code and extension number. The numbers can be separated by hyphens
., or spaces.
Area codes will be recognized when they are surrounded by parentheses, such as in the phone number
To recognize an extension, the function looks for a number following either
extension followed by the extension number.
- What it will find: +1 (123) 456-7890 ext. 3
- What it won't find: 123 456 7890
5. Extract URL
This function looks for a string of letters, numbers, and dashes, followed by a period, then a recognized top-level domain (TLD). It can also account for an "https://" or "http://" prefix, along with one or more subdomains, folders, and query parameters.
- What it will find: zapier.com/help/create/format?testing=true
- What it won't find: www DOT example DOT com
If these extract functions cannot find the text you need, you can use the Extract Pattern function to create a custom solution. Given the complexity of regular expressions, our support team cannot troubleshoot or provide support for them.
If you have questions about creating a custom regular expression pattern to meet your needs, we recommend reaching out to the Zapier Community.