Welcome to the Make community!
To do this, you can try using the Text parser “Match elements” module —
Searches string elements matching predefined patterns.
One of the patterns include “Email”.
For more information about the Match elements module and Text parser app, see the corresponding Integrations page and the Help Centre documentation.
Alternatively, you can use the built-in function:
- replace
replace(text; search string; replacement string)
Here’s an example of how you can use this function:
{{ replace(1.text; "/^[\w\W]*?([\w.+_-]+@[\w.+_-]+)[\w\W]*$/"; "$1") }}
Proof https://regex101.com/r/7OAt69/1
Hope this helps! If you are still having trouble, please provide more details.
— @samliew