Hi Guys
I have data below screen shot and I need only data
between “Project Contact(s):” and “Link Commissioning Market” e mail Id’s
and I am using this split methord
“str_EmailBody.Split({“Project Contact(s):”.ToString.Trim},StringSplitOptions.RemoveEmptyEntries)(1).ToString.Trim.Split({“Link”.ToString.Trim},StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim”
but what happen in some E-Mail I got which have “Link Commissioning Market” tag exist and in some data only new blank line can you please help me how to use blank line tag
apart from Link Commissioning Market tag
With this you are doing a condititional. If word “Link” exists it will delete the part of Link comissioning. If word doesnt exist, it will just get emails!
If (str_EmailBody.Split({“Project Contact(s):”.ToString.Trim},StringSplitOptions.RemoveEmptyEntries)(1).Contains(“Link”), str_EmailBody.Split({“Project Contact(s):”.ToString.Trim},StringSplitOptions.RemoveEmptyEntries)(1).ToString.Trim.Split({“Link”.ToString.Trim},StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim , str_EmailBody.Split({“Project Contact(s):”.ToString.Trim},StringSplitOptions.RemoveEmptyEntries)(1))
Is it ok for you do it with regex? It is easy, and you dont need to check if “Link” word exists…
Read Email body → str_EmailBody
2.Matches activity →
Create a variable (In this case I put Collection). This one is IEnumerable . That means that emails are saved in the variables similiar like Lists or Arrays do.
So, then we can iterate through the variable with a For Each activity to get each email:
Inside the For each I put a log message activity so you can check that each email is caught.
Check out my Regex MEGAPOST. It details how I learnt regex
Further to what @Angel_Llull said, Regex is simply a tool for matching a pattern of text within a larger body of text. You can use it to extract one item or a collection of results.
