If you need to separate part of the content from a field, you can do it by using the Formatter's
Extract Pattern transform. This allows you to use regular expressions (regex) to extract partial data from a field.
Regular expression is an advanced feature. Zapier doesn't offer email support for regular expression. If you encounter a problem, we recommend asking questions on Zapier Community or StackOverflow and tagging them with "Zapier".
The Input field can work with line items. It will look for the pattern in each item individually. However, this Formatter step won’t work with line items if the option Match All dropdown is set as Yes.
We have a few examples on how to extract text (website URLs, email address and phone numbers).
To refine your pattern match, select yes from the following dropdown options:
- Match All - Matches all occurrences of pattern. Returns results as line items. Note: If this option is set to Yes, the Input field won't work with line items.
- IGNORECASE - Ignore upper/lowercase differences for matching.
- DOTALL - Allow dot (.) to match newline normally it matches anything but newline.
- MULTILINE - Within a string made of many lines, allow ^ and $ to match the start and end of each line.
When setting the option Match All to Yes, we recommend creating group label in your pattern. This creates named properties in a line item, making it identifiable for use in your Zap later.
In this example, we want to create a group label called all_foo_bars, by using the pattern (?P<all_foo_bars>f[o]+ bar).
The step will show the results of the regular expression. If the regular expression finds a match, it will return it in the field output. As you can have multiple matches in your pattern, your output can vary. Each match will always return at least these fields:
0 - text of match_end - last position of match in text_start - first position of match in the text_matched - true or false based on the match
If you have multiple matches in your pattern, the first match will appear as 0, second match as 1 etc.
If you're using the option Match All, your results will be returned as line items.
Once you've set up this step, you can add another action where the result of the Formatter step will be used.