Hi guys I wanted some assistance here: I have a whole email here where I want extract an email body highlighted in blue.
So I am stripping off the ‘Please be cautious’ part and the ‘Yahoo Mail’ because I don’t need it. I am using these activities:
Another activity I use is:
The last activity:
But it just strips off almost everything and what I would want to extract. The other ones do not Strip off the body like this one
instead of images can you send as text, so that we can prepare exact syntax to get the output
Input value:
Expected output:
I see the pattern of paragraph. If that’s going to work for you, you can split the whole string with newline character and get the index 1 value as mail body.
strMiddleText = inputText.Split(New String() {Environment.NewLine, vbLf, vbCrLf}, StringSplitOptions.RemoveEmptyEntries)(1)
Expected output:
To whom it may be concern I wrote this email with a bleeding heart since I had no agreement about taking a life policy since I had with other company and I told your sales brocker I don’t need this police since I don’t understand about it and a premium is too much for me and I met him it was decreasing policies not pomp me with life cover and I tried to write to you guys and tell you about how I feel about this policy and I don’t need it I want to cancelled it and the 2nd one your sales brocker found out that you were still taking stop orders on my behalf of my father who passed and you paid it so I request this for the last if I don’t get help I will go through to found help out bodies to help really I’m so disappointed with your company that took my money that will help my kinds since I am a single parent I will attach my WhatsApp chat with your sales brocker that from day I didn’t want this policy I even don’t know how is working who in that policy please don’t send me any agreement policy policy because I don’t want it and need to cancel with immediately effect.
From unhappy 
customer. Shoba NA
Give this regex a try:
System.Text.RegularExpressions.Regex.Match(yourVariable, “(?<=attachments!\s)(.?)(?=\sYahoo mail: Search, organize, conquer)”, RegexOptions.Singleline).Value
Please send input as well
I can’t upload the message it’s hidden
you can add that in any notepad file and share
I still have not gotten it correctly, but I keep on trying.
There is another email body that I tested with:
In it I want to remove the part highlighted down below the email body from : “The ..llard Insurance company” until emaildisclamer.pdf.
Please help with a regex for this
Use below solution.
text = fullTextVariable ’ (Your input text from email or source)
pattern = “To whom it may be concern.?From unhappy .?customer. Shoba NA”
extractedBody = System.Text.RegularExpressions.Regex.Match(text, pattern, System.Text.RegularExpressions.RegexOptions.Singleline).Value
