Extract function and line break

Question

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
  )
)

", "[" ), "

", "]" ), "
", " " ) ), trim( "Additional Comments:" ), trim( "Your Workgroup" ) ), "][", char( 13 ) )

ankitab0001 · Accepted Answer

I figured out the solution. So I substituted the line break with a special character before extracting and then substituted again with char(13) after extracting substitute( substitute( extract( striphtml( substitute( substitute( substitute( pv!htmlBody, "

", "[" ), "

", "]" ), "
", "##" ) ), trim( "Additional Comments:" ), trim( "Your Workgroup" ) ), "][", char( 13 ) ), "##", char(13) )

ManuelHTG · Answer

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

Extract function and line break

Top Replies