Answered

Issues with text output

(0) Share

Report

Posted on by kljsdofiuapdf

Hello all. Hoping this is a simple thing, but not sure how to resolve. We have an SMS to email relay that changes the HTML to text (using the Html to text (preview)), and the output is correct, but is something like this (Number is fake and the URL is fake):

You've received an incoming SMS from John Doe to +185456731597:

Test 10 — ClickSend.com

[https://randomsuperlongurl.com]

Basically, I want to trim the output so that it ignores everything before the "+185456731597:" and everything from "— ClickSend.com" after, so that it just gives the output "Test 10" (or whatever that SMS would be).

I am trying to use compose inputs with no luck.

Any help would be greatly appreciated!

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Could you show the HTML output before Html to text (preview) action?

Was this reply helpful? Yes No
kljsdofiuapdf 15 on at

Like (0)

Report
Copy link

Link copied!

Sure! Here it is:

Was this reply helpful? Yes No
kljsdofiuapdf 15 on at

Like (0)

Report
Copy link

Link copied!
Sorry, misunderstood. Here is (part) of the HTML from the body of the ingested email:
"subject":"Incoming SMS from John Doe","bodyPreview":"You've received an incoming SMS from John Doe to +185456731597:\r\nTest 12\r\n— ClickSend.com","importance":"normal","conversationId":

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

No I mean real HTML text in Body.

Was this reply helpful? Yes No
kljsdofiuapdf 15 on at

Like (0)

Report
Copy link

Link copied!

Sorry, I posted it above once I re-read your post.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @kljsdofiuapdf

Please try:

trim(first(split(last(split(outputs('Html_to_text')?['body'],'+185456731597:')),'— ClickSend.com')))

Best Regards,

Levi

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!
split(triggerOutputs()?['Body/Body']?['bodyPreview'],decodeUriComponent('%0D%0A'))[1]

Was this reply helpful? Yes No
kljsdofiuapdf 15 on at

Like (0)

Report
Copy link

Link copied!

Marked answer as solution. Thank you so much for your help, this was driving me crazy!!

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Note my approach doesn't require "Html To Text" action at all.

Was this reply helpful? Yes No