+2Hi,
I have a question about formulas,
I have a longtext field extracted from an Email Body and I would like to find inside this field if there is any mail marked like this :
“From : email@domain.com”
and extract just the mail to put it in.
For information, I don’t know the line in question, it may have text after the email and the domains are not the same.
I have tried Regex but I have not succeed.
Thanks
+21Hi there! The following REGEX should work:
REGEX_EXTRACT([YOUR TEXT FIELD], "([a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\\.[a-zA-Z0-9_-]+)")
Let me know is that solves it!
+2Hi there! The following REGEX should work:
REGEX_EXTRACT([YOUR TEXT FIELD], "([a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\\.[a-zA-Z0-9_-]+)")
Let me know is that solves it!
Hi !
thanks for the answer is gets mails but it ignores the "From : " Tag so I got anomalies and mails I don’t want
.(#ERRORS are empty fields so it’s OK)
+21Hi !
thanks for the answer is gets mails but it ignores the "From : " Tag so I got anomalies and mails I don’t want
.(#ERRORS are empty fields so it’s OK)
Sorry, this should match all From: email@email.com:
REGEX_EXTRACT({Formula 2}, "([From:+\\s]+[a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\\.[a-zA-Z0-9_-]+)")
Thank you I’ll look at it today But I think there will be an issue because of the space after “From” and “:”
I have managed to do something similar with
IF(FIND("From : ", {table})>0,REGEX_EXTRACT(RIGHT(table, LEN(table)-FIND("From : ", {table})-4), "([a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\\.[a-zA-Z0-9_-]+)"), "")
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.