Problem Statement: I am trying to extract a list of string from an html content using the extract function and a combination of striphtml() and substitute(). The list of string contains a couple of line breaks but the extract function is stripping the line breaks. My goal is to keep the line breaks intact. I tried substituting the line breaks with space, it works. But char(13) does not work.
Sample code:
substitute( extract( striphtml( substitute( substitute( substitute( pv!htmlBody, "<p class=MsoPlainText>", "[" ), "</p>", "]" ), "<br>", " " ) ), trim( "Additional Comments:" ), trim( "Your Workgroup" ) ), "][", char( 13 ) )
Discussion posts and replies are publicly visible
Hi ankitab0001
Could you provide a html example?
Anyways, I think you might need to use char(10) -line feed- instead of char(13) -carriage return-
Best,
Manuel
I used both.. char(10) and char(13). Didn't work