How to extract dynamic text from weekly email

[michael_j_brady]

Hi all - I am a citizen developer and new to UiPath. I’ve completed the basic trainings. I want to extract specific text from an email whose contents changes every week, but will always have the building name contained in the text string that i want.

For example, i want to only extract all of the text regarding Skytower below:

• Walnut plaza 12/13/23 event to be discussed
• Skytower 12/04/23 big event with 200 people
• Skytower 12/13/2023 chairs and tables for 630 people and the CEO
• Skytower tables and desks
• Hickory Plaza 12/12 ice cream social

[postwick (Paul Ostwick)]

Use Regex in the Find Matching Patterns activity:

The Result will be an ienumerable of all matches.

[pravallikapaluri]

Hi @michael_j_brady

Skytower[^\r\n]*

1. Get Outlook Mail Messages
2. For Each Email in MailMessages
    3. Assign: extractedText = System.Text.RegularExpressions.Regex.Match(Email.Body, "Skytower[^\r\n]*").Value
    4. Log Message: "Extracted Text: " + extractedText

Hope it helps!!

[Steven_McKeering]

Hello @michael_j_brady

You can learn more about regex from my Megapost

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

Cheers

Steve

[Parvathy (PS Parvathy)]

Hi @michael_j_brady

=> Use Get Outlook Mail Messages to retrieve the messages and store the output in a variable.
=> Run a For Each loop to iterate through list (MailMessages) variable.
=> Inside the loop, use assign activity and give below syntax:

str_Body= CurrentMail.Body.ToString

=> Use the below syntax in another assign activity:

text= System.Text.RegularExpressions.Regex.Matches(str_Body,"Skytower(.*)")

OutputDataType is IEnumerable(System.Text.RegularExpressions.Match)

=> Run a For Each loop for text variable and print the message using Log Message.

Hope it helps!!

[postwick (Paul Ostwick)]

It’s not necessary to assign to separate variables (str_Body and text). Just do…

System.Text.RegularExpressions.Regex.Matches(CurrentMail.Body,"Skytower(.*)")

…in the “In” property of the For Each.

[sanjay3 (Sanjay)]

Hi @michael_j_brady

Can you try this

System.Text.RegularExpressions.Regex.Match(emailBody, “(?m)^(.Skytower.)$”).Value