Unanswered

HTML to Text Line Breaks

(0) Share

Report

Posted on by Wzaorski

I am trying to parse out readings from automated emails from customers,
However, when I am trying to use HTML to text, it is removing the proper line breaks, making it hard to get the numbers I am trying to isolate to an excel sheet:

Screenshot 2022-02-20 093122.png

I am trying to use a filter array and splits to get the number value out.

Is this the correct approach to getting data out of the emails?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Wzaorski

Is your email format is always consistent. What numbers you after here? Could you please explain?

Thanks

Was this reply helpful? Yes No
Wzaorski 13 on at

Like (0)

Report

Thanks @abm,
The emails are always constant and automated, each customer varies a little on format,
here is one (raw input):
<p>
CAUTION: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Current tag data:
Carbon Actual Weight = 125498
Sent at: 02-18-22 07:00:00 PM
This email and its attachments, if any, are intended for the personal use of the named recipient(s) and may contain confidential, privileged, or proprietary information. If you are not a named recipient, or an agent responsible for delivering it to a named recipient, you have received this email in error. In that event, please (a) immediately notify me by reply email, (b) do not review, copy, save, forward, or print this email or any of its attachments, and (c) immediately delete and/or destroy this email and its attachments and all electronic and physical copies thereof. Thank you.
</p>
The another is in the screenshot.

I need to pull out the EMCI and the Moca on the screenshot, and the single Lbs number on the example above.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Wzaorski

Based on the first message here is the flow I built.

Above expressions are as follows:

split(outputs('Compose'),outputs('Compose_2'))

last(split(outputs('Compose_3')[4],':'))

last(split(outputs('Compose_3')[5],':'))

My test result:

Was this reply helpful? Yes No