Unanswered

Extracting text from email

(0) Share

Report

Posted on by Uddinf

I have managed to extract text from one point to another - I used Html to text and by using Compose :

trim(first(split(last(split(body('Html_to_text'),'When will this happen:')),'How this will affect your organization:'))) that seems to work .

However trying to extract some text without capturing links/logos from the email - For example see screen shot I would like to grab all the text before 'When this will happen' and also not include the Microsoft Logo... Any ideas ?

I tried to use 'Filter array'

and compose :

join(split(body('Filter_array')[4], ' '), ' ') - Not working

All responses (2)

Answers (0)

Uddinf 11 on at

Like (0)

Report

Re: Extracting text from email

@v-bofeng-msft thanks for your response.

I am already using 'Html to text'

And also got s Filter array the Outputs for length

And using Split function
join(split(body('Filter_array')[2], ' '), ' ')

This is the complete flow :

My aim is that I do not want to pick up the Microsoft logo on the top of the email. just want to extract the heading text.
v-bofeng-msft on at

Like (0)

Report

Re: Extracting text from email

Hi @Uddinf ,

I suggest you to add a 'Convert HTML to text' to convert the email into plain text and then use the split function to get the string before 'When this will happen:'.

Best Regards,

Bof