How to extract and email address from my HTML text

Questions & Answers
1

To get helpful responses

I am trying to extract the names and email addresses from my emails and place them in a Google sheet. I converted the HTML to text with a text parser and then edited a new module to extract the date from the text This is working however I am running into the issue that a certain word “Uw” is placed behind the email address.
This is the search pattern:
Uw e-mailadres:\s*([a-zA-Z0-9_.±]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+)

Scherm­afbeelding 2024-03-12 om 13.27.22
Scherm­afbeelding 2024-03-12 om 13.27.221802×1422 173 KB

Help would be great,

2

Hey @A.menting

Try this :

([a-zA-Z0-9._%±]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,})

3 Likes
3

Thank you for the quick reply,

The outcome there is that also the email from the sender (internal email address) and the email from within the email will get extracted, however, the word “Uw” is still at the end of the extracted email address that was within the text

4

I found the solution. just added ‘s*Uw’ to the string

2 Likes
5

Hello @A.menting :wave:

I just want to quickly say congrats on figuring this one out! :clap:

Thanks a lot for stepping back in here and sharing what did the final trick with the rest of us. This could be super helpful to many others who are looking for similar info. :pray:

2 Likes