Help in extracting email

[Sudish_Babu]

I am trying to extract email from an email body.

The sample mail body is as below.

Email: abc@gmail.com
Status: Price Too High
Message: Test Message

I want to copy each as a separate Colum in excel.

expected output in excel

Email Status Message
abc@gmail.com Price Too High Test Message

Thanks

[Srini84 (Srinivas Kadamati)]

@Sudish_Babu

You can write Regex for extracting the Email, Status, Message as below

Create a variable for Mail body like MailBody = Item.Body.ToString

Create a variable as EmailAddress and Write Regex as below for Email

EmailAddress = system.text.regularexpressions.regex.Matches(MailBody, “(?<=Email:).+”)

This will extract the email address likewise write for remaining

And use Add datarow activity to write back to the datatable

Hope this will help you

Thanks

[Sudish_Babu]

@Srini84

system.text.regularexpressions.regex.Matches(MailBody, “(?<=Email:).+”)

Cannot assign from type ‘System.Text.RegularExpressions.MatchCollection’ to type ‘System.String’ in Assign activity ‘Assign’.

I am getting an error like this

[Srini84 (Srinivas Kadamati)]

@Sudish_Babu

Can you share the screenshot of your workflow?

Thanks

[Sudish_Babu]

the error is gone.

the actual mail body is also attached
mail body.txt (1.4 KB)

Help is appreciated.

[ppr (Peter Preuss)]

ensure following:

Also have a look here:

[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…

Also working with your txt file content:

[Srini84 (Srinivas Kadamati)]

@Sudish_Babu

Great!!

Please mark as solution and close this thread if this helps, so that others can benefit from this

Happy Automation

Thanks