Unanswered

HTML to Text Function causing line break

(0) Share

Report

Posted on by RLSid17

219

Hi,

I'm trying to do a HTML to text conversion whenever an email arrives. So I have this text that is causing a "\n" For example:

Short Description: Ceiling is leaking need to fix

But when it converts to text it shows as:

"Short Description: Ceiling is leaking",

"need to fix",

I needed to extract the specific texts from other fields but this one is causing it to move 1 line messing up the entire flow.

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

manuelstgomes 6,625 on at

Like (1)

Report
Copy link

Link copied!
HI @RLSid17

Correct me if I'm wrong, but do you need to remove the \n from the text?

Did you try a simple replace function, or it's a bit more complex than this? Something like:

replace(<HTML TEXT>, '\n', '')

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members find the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
RLSid17 219 on at

Like (0)

Report
Copy link

Link copied!

Hi @manuelstgomes

Yes I do need to remove the \n from that specific line only. Since it the format of the email is fixed and this line break is causing it to add one more line.

It still reads as:

Short Description: Ceiling is leaking
need to fix

instead of:

Short Description: Ceiling is leaking need to fix

Please take note that in the email it is showing as one complete sentence.

I tried the function you suggested and it doesn't do anything

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (1)

Report
Copy link

Link copied!

HI @RLSid17

Can you check something for me? In the long string that has the whole email, can you localize the "Ceiling is leaking" and check if the character is precise "\n"? For example, it could be <br> or \\n, so we're sure it works.

If not, can you please copy the small HTML section so we can replicate it and try to help you?

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members find the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
RLSid17 219 on at

Like (0)

Report
Copy link

Link copied!

Hi @manuelstgomes

This is the output from the html to text conversion. I had to change the description due to our company policies but below is an example. I noticed when I triggered a different email depending on how short is the description, it would not cause a new line. So I'm guessing if it's a long description, it caused a new line just like below.

"body": " \n\nShort Description: Ceiling is leaking\nneed to fix

But in the original email it displays as Short Description: Ceiling is leaking need to fix.

Was this reply helpful? Yes No
RLSid17 219 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Any solutions to this?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @RLSid17 ,

I assume you have only one "column" in the body, what you need is to remove the new line tag \n from after the Description, please try below method:

concat(first(split(<HTML TEXT>, 'Short Description')),'Short Description',replace(last(split(<HTML TEXT>, 'Short Description')),'\n','')

Best regards,

Was this reply helpful? Yes No
RLSid17 219 on at

Like (0)

Report
Copy link

Link copied!

Hi,

It is saying expression is invalid.

The expression for my html to text is 'HTML_to_text' tried to change that but it is still invalid.

Was this reply helpful? Yes No
RLSid17 219 on at

Like (0)

Report
Copy link

Link copied!

I kinda have a workaround which makes it into a 1 long string:

replace(body('Html_to_text'),outputs('EnterKey'),'')

So I needed to create several Compose Data Operation for each fields.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RLSid17 ,

I missed a closing parenthesis at the end of the formula.

concat(first(split(<HTML TEXT>, 'Short Description')),'Short Description',replace(last(split(<HTML TEXT>, 'Short Description')),'\n',' '))

Best regards,

Was this reply helpful? Yes No