this is a follow up question from my previous question. I'm having trouble when I want to convert HTML strings to plain text without HTML tags in google app script using the reference in

Or you can use this sample spreadsheet.

Is there any step that I miss or I do wrong?

Thank you before for answering the question

CodePudding user response：

In your situation, how about modifying toStringFromHtml as follows?

Modified script:

function toStringFromHtml(html) {
  html = '<div>'   html   '</div>';
  html = html.replace(/<br>/g, "").replace(/<p><\/p><p><\/p>/g, "<p></p>").replace(/<span>|<\/span>/g, "");
  var document = XmlService.parse(html);
  var strText = XmlService.getPrettyFormat().setIndent("").format(document);
  strText = strText.replace(/<[^>]*>/g, "");
  return strText.trim();
}

• In this modified script, your following sample HTML is converted as follows.

  • From

      <p><span>Hi Katy</span></p>
      <p></p>
      <p><span>The illustration (examples) paragraph is useful when we want to explain or clarify something, such as an object, a person, a concept, or a situation. Sample Illustration Topics:</span></p>
      <p></p>
      <p></p>
      <p><span>1. Examples of annoying habits people have on the Skytrain.</span></p>
      <p><span>2. Positive habits that you admire in other people. </span></p>
      <p><span>3. Endangered animals in Asia. </span></p>
    

  • To

      <div>
        <p>Hi Katy</p>
        <p></p>
        <p>The illustration (examples) paragraph is useful when we want to explain or clarify something,
          such as an object,
          a person,
          a concept,
          or a situation. Sample Illustration Topics:</p>
        <p></p>
        <p>1. Examples of annoying habits people have on the Skytrain.</p>
        <p>2. Positive habits that you admire in other people. </p>
        <p>3. Endangered animals in Asia. </p>
      </div>
    

  • By this conversion, the following result is obtained.

      Hi Katy
    
      The illustration (examples) paragraph is useful when we want to explain or clarify something, such as an object, a person, a concept, or a situation. Sample Illustration Topics:
    
      1. Examples of annoying habits people have on the Skytrain.
      2. Positive habits that you admire in other people.
      3. Endangered animals in Asia.
    

Note:

• When your sample HTML shown in your question is used, the modified script can achieve your goal. But, I'm not sure about your other HTML data. So I'm not sure whether this modified script can be used for your actual HTML data. Please be careful about this.