0

I'd like to search a text from the response and extract from text to text.

var resp = UrlFetchApp.fetch("https://www.w3schools.com/tags/tryit.asp?filename=tryhtml_select");
var response = resp.getContentText();

I've to parse this response

<!DOCTYPE html>
<html>
<body>

<h1>The select element</h1>

<p>The select element is used to create a drop-down list.</p>

<form action="/action_page.php">
  <label for="cars">Choose a car:</label>
  <select name="cars" id="cars">
    <option value="volvo">Volvo</option>
    <option value="saab">Saab</option>
    <option value="opel">Opel</option>
    <option value="audi">Audi</option>
  </select>
  <br><br>
  <input type="submit" value="Submit">
</form>

<p>Click the "Submit" button and the form-data will be sent to a page on the 
server called "action_page.php".</p>

</body>
</html>

I need text and values so I think something like this

text to search = "<select name="cars" id="cars">"
start text = "<option value="
end text = "</select>"

text to extract and export in two columns

volvo   Volvo
saab    Saab
opel    Opel
audi    Audi

How to approach correctly?

Zimox
  • 69
  • 1
  • 6
  • You could use regular expressions or XmlService but personal I write snippets to do things like this on the live DOM in the browser – Cooper Oct 01 '21 at 15:35
  • I suggest you to use [Cheerio](https://github.com/cheeriojs/cheerio) library to do what you want. – Yann LM Oct 01 '21 at 16:54

0 Answers0