Databases
StackOverflow2013
Postsdbo
POextract the first fully formed sentence from a html dump of a webpage
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POextract the first fully formed sentence from a html dump of a webpage
    primarykey
    data
    text
    <p>I am developing an application using PHP that extracts all sentences from another webpage using CURL to do so. though i am able to extract all data, i am finding difficulties extracting a fully formed sentence. i have referred to all the related questions and dint help me exactly the way i wanted. Please advice</p> <p>html content from where i need to extract a fully formed sentence</p> <pre><code>&lt;p&gt;&lt;font size="1" color="#C0C0C0"&gt;© Copyright &lt;br&gt;&lt;/font&gt;&lt;a href="http://www.dddddd.com" target="_blank"&gt;&lt;font size="1" color="#C0C0C0"&gt;apple orange Ltd&lt;/font&gt;&lt;/a&gt;&lt;font size="1"color="#C0C0C0"&gt;&lt;a href="http://sm2.dddd.com/stats.asp?site=sm2ph0t0" target="_top"&gt;&lt;img src="http://sm2.dddd.com/meter.asp?site=sm2ph0t0" alt="Site Meter" border=0&gt;&lt;/a&gt;&lt;/font&gt;&lt;/p&gt;&lt;/td&gt;&lt;td valign="top" width="24"&gt;&lt;/td&gt;&lt;!--msnavigation--&gt;&lt;td valign="top"&gt;&lt;p align="center"&gt;&lt;a href="http://www.orangeapple.com" target="_blank"&gt;&lt;img border="0" src="asddaf.jpg" alt="Sponsored by Ace Murder Mystery" width="85" height="121"&gt;&lt;/a&gt;&lt;font face="Times New Roman"&gt;&lt;b&gt;&lt;b&gt;&lt;u&gt;Posters&lt;/u&gt;&lt;/b&gt;&lt;br&gt;&lt;font size="3" color="#008080"&gt;To find a large selection of jay joes prints and posters including framing options, please type the word..&lt;font color="#996633"&gt; asdasd &lt;/font&gt;&lt;/a&gt;&lt;font color="#996633"&gt;&amp;nbsp;&lt;/font&gt; in the box below:&lt;br&gt;&lt;b&gt; </code></pre> <p>Basically if you notice there are lots of irrelavant sentences that might come out. i would want to extract a sentence from the above which has a minimum of "6" words in a string i should get "To find a large selection of jay joes prints and posters" as an output.</p> <p>Thanks, Jay</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJay66online
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POextract the first fully formed sentence from a html dump of a webpage
      1. This table or related slice is empty.
      1. VTClose
    2. VO
      singulars
      1. POextract the first fully formed sentence from a html dump of a webpage
      1. This table or related slice is empty.
      1. VTDownMod
    1. COHow will the sentences be delimited?
      singulars
      1. POextract the first fully formed sentence from a html dump of a webpage
      1. USPeeHaa
    2. COhmmmm.. preferably if the page developers have taken care of this it should be wit a full stop , but if its not i wouldn't mind a long concatenated string as i would only be extracting the first 50 words. hope that answers your question
      singulars
      1. POextract the first fully formed sentence from a html dump of a webpage
      1. USJay66online
    3. COa full stop with make the sentence: "© Copyrightapple orange LtdPostersTo find a large selection of jay joes prints and posters including framing options, please type the word."
      singulars
      1. POextract the first fully formed sentence from a html dump of a webpage
      1. USPeeHaa
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload