A*First Name*:* Hello *Last Name*:* test *Date of birth (mm/dd/yyyy)*:* 2023-02-01 *Applicant's Daytime Telephone Number:* 1234567890 *Applicant's Mobile Telephone Number:* *Applicant's Email address:*
In the above example I would extra “Hello” and “1234567890”
Is there a way to combine Steps 2 and 3 into one step?
Best answer by simplifywork
Short answer: not with regular expressions (and possibly not at all, depending on source/format/other things)
Long(er) answer: regular expressions are really powerful, but they’re limited by the type of character you’re searching for and/or the order in which those characters appear in a given body of text. They’re great at finding/extracting regular patterns, but combining letters and numbers in unpredictable ways with lots of characters in between them is too irregular.
If it’s any consolation, if your solution is currently working then it looks like you probably have the best solve for your particular situation.
With that said, the formatting you shared seems to suggest that the data is originating from a service that isn’t the email itself. Do you have direct access to the original data source? If so, you could cut out the email entirely and possibly save time (and zaps!) in the process. If you have direct access to the data source, let me know and we can work through a solution together!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Short answer: not with regular expressions (and possibly not at all, depending on source/format/other things)
Long(er) answer: regular expressions are really powerful, but they’re limited by the type of character you’re searching for and/or the order in which those characters appear in a given body of text. They’re great at finding/extracting regular patterns, but combining letters and numbers in unpredictable ways with lots of characters in between them is too irregular.
If it’s any consolation, if your solution is currently working then it looks like you probably have the best solve for your particular situation.
With that said, the formatting you shared seems to suggest that the data is originating from a service that isn’t the email itself. Do you have direct access to the original data source? If so, you could cut out the email entirely and possibly save time (and zaps!) in the process. If you have direct access to the data source, let me know and we can work through a solution together!
Heya @hippopotamuschicken! It’s tough to say without knowing the entirety of the workflow you’re considering. 🙂
A lot of it would depend on:
1.) If you have access to the original source, as @simplifywork mentioned
2.) If Zapier offers an integration for that app
If the first is true, I might recommend checking out our directory of apps here to see if there is an applicable trigger related to what you’re looking to achieve.
Otherwise though, as they also mentioned, it sounds as if you’ve found the best solution for your needs - which is awesome! 🤗
