Extract specific text from e-mail email

studio

#1

Can anyone help me
How to extract a particular text from e-mail


#2

@MdEbrahim

You can use RegEx Check this


#3

You can also use string functions like index of to find the index of string then use substring function to extract the string from email.


#4

Can you say in detail


#5

Can you send the main function


#6

Hi,

I explain you with example we use string functions index of and substring used in vb.net.

Here we use index function to find the index of text to find before it then use substring function to extract the data after it ,

“Quicklook ID” is a string before the extracted word .

Store this in a variable ind1 = message.Body.tostring.IndexOf(“Quicklook ID”)

                                Str1= message.body.tostring.Substring(ind1,message.Body.ToString.IndexOf("Division")-ind1)

We use “Division” is string after specific word to extract and then we remove the string which index we have given.

In case of any issue please let me know.

Thanks & Regards

Isha Grover


#7

Thanks
But still I get error


#8

Can you please share a sample e-mail content with the specific text that is to be extracted?


#9

1542783071941_mailread.xaml (7.2 KB)
Could you please recheck this and send the correct one


#10

Check this. 1542783071941_mailread.xaml (9.5 KB)


#11

Thanks
But I have occurred error
“Workflow designer encounter problems with you document”


#12

Can you able view the content of workflow if not executing? You should check the variable section how RegEx is used


#13

Thanks let will check it