Extract Data from Body of Email

[VegitlX_HuNteR]

Hi,

I have an email and the challenge that I have is getting information from it.
Please see screen shot. I would like to get the Hi Allain and also the date.
Right now I am getting the entire body of the email. I appreciate your help with this.

[Yoichi]

Hi,

How about the following expressions

Hi Allain

System.Text.RegularExpressions.Regex.Match(strMailBody,"Hi.*?,").Value

date

System.Text.RegularExpressions.Regex.Match(strMailBody,"Date:.*?\d{4}").Value

Regards,

[VegitlX_HuNteR]

should i enter this in an assign activity?

[Yoichi]

Hi,

@VegitlX_HuNteR

should i enter this in an assign activity?

Yes. Please use Assign activity as the following

strDate = System.Text.RegularExpressions.Regex.Match(strMailBody,"Date:.*?\d{4}").Value

[VegitlX_HuNteR]

Thanks buddy , I got it working now