Display first word or sentence on html page?


#1

is it possible to use one of the functions to display first word or sentence on html page?

if there is, i can't find it. 8-(


#2

Try this:

First, use a function such as XPathOnUrl() to scrape the desired block of text from the page. Here's how you would get the 'first <p> text' on SeoToolsForExcel's homepage:

=XPathOnUrl( "https://seotoolsforexcel.com/", "(//p/text())[1]", , , "text")

Next, use RegexpFind() to get the first word or sentence.

First word (assuming above result is in A1):

=RegexpFind(A1, "(\w+)", 1)

or First sentence:

=RegexpFind(A1, "([^\.\?!]+)", 1)

Hope this helps!
-Tim