Hi there!
Need some help on this complex ask -I have two emails listed in the Event Description that I will need to format/extract. I can do the first one easy through formatting action but will this need code to by pass the first email to parse out the second email?
Best answer by SamB
View original
Hi there
Thanks for reaching out with your question. I would love to try to help you with this.
I might not understand your problem fully, so please do let me know if I am off, but I wonder if the Split text feature could help within the Formatter function.
You can look at it here: https://zapier.com/help/doc/how-use-formatter-functions#using-split-text
Let me know if this helps at all.
+12
Hi
A code step with Regex can match any email like text in a string. The regex for which can get complicated. Alternatively, you can chain together Zapier actions to find more than 1 email.
As you’ve discovered, you can use the formatter action to retrieve the first one. Unfortunately, Zapier will always retrieve the first match.
However, once you’ve found the first email, you can follow it up with another formatter action to find and replace the first found email with a blank value. This will return the event description without the first email.
Now that the first email isn’t there, you can use a final formatter action to match to the next email address.
+11
Hey
Just checking in to see if you managed to extract multiple email addresses using a Formatter (Split Text) or Code step? Or did you find another way?
If not, you may want to try using a Formatter (Text > Extract Pattern) step. It should allow you to extract multiple email addresses - How to Extract Email Addresses, Phone Numbers, and Links From Text
Hope this helps!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
