Email Body Extract

[aparna30 (Aparna)]

How can i extract purpose, property note type,notes from email body eg Create new and all?
Purpose: Create New
Property Note Type: Grease Trap
Property Status: Pending
Notes: RPA Test – LL reported PX grease trap leaking into downstairs tenant. Contacted FM and GM to have PX vendor investigate ASAP and make needed repairs.

[pravin_calvin (pravin kumar)]

Hi @aparna30

Your steps could as follows

Use GetOulook or Imap mail activity to read the mail messages.

Use For each and Change the type argument to mail message.

With in the body of the loop use Item.Body.Tosting it will Display the body of the mail as String

The use regex to match the value you need to fetch the value you need!

Check with the post below to fetch value using regex!

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…

Regards

[ppr (Peter Preuss)]

give a try on this generic pattern

^(.*?)(?:\:)(.*?)$

And rely on groups (you would later trim the values)

Along with the Post from @Steven_McKeering you will also get the link to and vice versa:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[aparna30 (Aparna)]

@ppr Thank you

[aparna30 (Aparna)]

How can i get these 4 matches in a variable?

[Jobin_Joy]

Hi @aparna30

Please use below inline code,

Thank you @ppr for this

Kindly check/test the given solution and close the topic by marking the solving post as ‘solution’. Thank you.

[ppr (Peter Preuss)]

Depending on the needs we can look for a datatype supporting us for the next processing steps

e.g. Dictionary:

myMatches.Cast(Of Match).toDictionary(Function (m) m.Groups(1).toString, Function (m) m.Groups(2).toString.Trim)

Array:

myMatches.Cast(Of Match).Select(Function (m) m.Groups(1).toString.Trim & ":" & m.Groups(2).toString.Trim).toArray