Databases
StackOverflow2013
Postsdbo
POCleaning up scraped Nokogiri output
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCleaning up scraped Nokogiri output
    primarykey
    data
    text
    <p>The output of what I'm scraping leaves me with this:</p> <pre><code>&lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic1" class="the text"&gt;I like turtles&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic2" class="the text"&gt;I like bears&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic3" class="the text"&gt;I like ruby&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic4" class="the text"&gt;I like oranges&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic5" class="the text"&gt;I like keyboards&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic6" class="the text"&gt;I like movies&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic7" class="the text"&gt;I like Android&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic8" class="the text"&gt;I like Mac&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic9" class="the text"&gt;I like music&lt;/span&gt;&lt;/li&gt; &lt;li&gt;&lt;img class="static" src="pic.jpg"&gt;&lt;span id="dynamic10" class="the text"&gt;I like boats&lt;/span&gt;&lt;/li&gt; </code></pre> <p>There is about 100 lines of this with the span class being different each time, and the "I like turtles" part being different each time. </p> <p>Ideally, I only want the "I like turtles" part of each line. Is there a way to get this? </p> <p>Example 10 lines</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USStn
    1. USStn
    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
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThere is a way; might help if you post 10 of those hundred lines as we can determine the right pattern...
      singulars
      1. POCleaning up scraped Nokogiri output
      1. USRuss Clarke
    2. COis it right to assume your `span`, regardless of the `class`, always follows (like in `following-sibling`) the `img` and is a child to the `li`?
      singulars
      1. POCleaning up scraped Nokogiri output
      1. USPavel Veller
    3. CO10 lines added.
      singulars
      1. POCleaning up scraped Nokogiri output
      1. USStn
 

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