I am extracting data from hundreds of emails and was wondering how I could extract certain type of words right after certain type of text from a long string.
from below, i want to retrieve
firstname.lastname@example.org and email@example.com
since they are always in the same format, I want to manipulate my email string to retrieve emails after "From: " and assign it to variables and store it in a datatable.
any guidance on how to store two (or more) emails after text "From: " would much be appreciated!!!
Subject: RE: New supplier testPerson approval & testrequired for ticket 12312321312313
From: (test guest) firstname.lastname@example.org
To: (test) email@example.com
Date: 9/06/2021 9:41:19 a.m.
Subject: RE: New supplier approval & testrequired for 1376611
From: (test) firstname.lastname@example.org
To: (test guest2 ) email@example.com
Date: 3/06/2021 12:43:16 p.m.