Ok. So you're only trying to retrieve the
h2 titles? Because according to the link, there are a total off 3
"Affordable" If you include the h3 header.
I'm not sure if you only need to return the word
"affordable" no matter what case it's in, or if you need to extract all the headers that include the word
Easiest way in my opinion: CsQueryOnUrl
If you simply want all the h2 headers,
CsQueryOnUrl will make this easy. For this, with
A2 as your URL, just use this to return all the headers..
To explain, all the H2 headers you are looking for are within the
div element that contains the
class attribute of
entry-content. Therefore, seprating the h2 with a space on the div container according to the CSS SELECTOR syntax, will return all
h2 within that specified
Dump befofore the entire
CsQueryOnUrl simply takes all those possible results, or an array, and literally "Dumps" them into the rows below. If you want the Dump to span across the columns, or horizontally, you can use the boolean value for the
transpose variable in the function like so:
TRUE factor at the end of the function. This will "Transpose" your data in the other direction so to speak.
Now here it is again using: XPathOnUrl
Here's what it looks like in Excel with the results from both functions side-by-side.
Let me know if this isn't what you're looking for. But that's basically what I understood as the data you're looking for.
ADDITION TO POST:
Here's a simple guide for CSS SELECTOR elements and how they work on the pages:
w3schools.com - CSS Selectors
Definitely try their tester too, you can click on specific elements and it will highlight them in action as you click. It's on that same link, but here's the direct link to their little web app:
w3schools.com - CSS SELECT it Yourself
Also, here's one for XPath:
w3schools.com - XPath Syntax
XPath is sometimes needed for cases where css syntax will not achieve the desired output. The good thing about XPath is that it has those additional features where you CAN search by
contains(text() as you originally had planned.