Scrape Link Path if contains

I'm wanting to use the isfoundonpage or XpathOnURL to scrape the internal link path for links that contain certain words.

For example....

Visit this page example.com and search for internal links containing the word "community" and grab the page path or full URL. (Result = example.com/community.html )

What is the best way to do this?

Found the answer.

=XPathOnUrl(A100,"//a[contains(translate(text(),'COMMUNITY','community'), 'community')]/@href","href")

1 Like