Databases
StackOverflow2013
Postsdbo
POCsQuery - getting sibling values between two selectors?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCsQuery - getting sibling values between two selectors?
    text
    copied!<p>I'm trying to parse out values from a large HTML page and I'm struggling with how to extract text from between two selectors. Here's my example HTML to illustrate:</p> <pre><code>&lt;table class="categories"&gt; &lt;tr class="category"&gt; &lt;td class="categoryTitle"&gt;Category #1&lt;/td&gt; &lt;td class="categoryDate"&gt;12-1-2012&lt;/td&gt; &lt;td class="categoryFoos"&gt;212&lt;/td&gt; &lt;/tr&gt; &lt;tr class="catItem"&gt; &lt;td class="catItemName"&gt;&lt;div class="itemName"&gt;Category Item #1&lt;/div&gt;&lt;/td&gt; &lt;td class="catItemColor"&gt;Blue&lt;/td&gt; &lt;td class="catItemSprockets"&gt;17&lt;/td&gt; &lt;/tr&gt; &lt;tr class="catItem"&gt; &lt;td class="catItemName"&gt;&lt;div class="itemName"&gt;Category Item #2&lt;/div&gt;&lt;/td&gt; &lt;td class="catItemColor"&gt;Red&lt;/td&gt; &lt;td class="catItemSprockets"&gt;454&lt;/td&gt; &lt;/tr&gt; &lt;tr class="catItem"&gt; &lt;td class="catItemName"&gt;&lt;div class="itemName"&gt;Category Item #3&lt;/div&gt;&lt;/td&gt; &lt;td class="catItemColor"&gt;Purple&lt;/td&gt; &lt;td class="catItemSprockets"&gt;11&lt;/td&gt; &lt;/tr&gt; &lt;tr class="category"&gt; &lt;td class="categoryTitle"&gt;Category #2&lt;/td&gt; &lt;td class="categoryDate"&gt;12-17-2012&lt;/td&gt; &lt;td class="categoryFoos"&gt;311&lt;/td&gt; &lt;/tr&gt; &lt;tr class="catItem"&gt; &lt;td class="catItemName"&gt;&lt;div class="itemName"&gt;Category Item #1&lt;/div&gt;&lt;/td&gt; &lt;td class="catItemColor"&gt;Yellow&lt;/td&gt; &lt;td class="catItemSprockets"&gt;73&lt;/td&gt; &lt;/tr&gt; &lt;tr class="catItem"&gt; &lt;td class="catItemName"&gt;&lt;div class="itemName"&gt;Category Item #2&lt;/div&gt;&lt;/td&gt; &lt;td class="catItemColor"&gt;Red&lt;/td&gt; &lt;td class="catItemSprockets"&gt;5&lt;/td&gt; &lt;/tr&gt; &lt;tr class="catItem"&gt; &lt;td class="catItemName"&gt;&lt;div class="itemName"&gt;Category Item #3&lt;/div&gt;&lt;/td&gt; &lt;td class="catItemColor"&gt;Purple&lt;/td&gt; &lt;td class="catItemSprockets"&gt;11&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p>How would I go about taking a ICsqWebResponse and parsing out each Category, with the title, date and 'foos', as well as all of the Items in each Category as a collection of items? Just so it's clear what I'm trying to end up with, the object should something look like this:</p> <pre><code>Categories = { Category #1 { Date: 12-1-2012, Foos: 212, Items: [ Category Item #1 { Color: Blue, Sprockets: 17 }, Category Item #2 { Color: Red, Sprockets: 454 }, ... more items ... ] }, Category #2 { Date: 12-17-2012, Sprockets: 311, Items: [ Category Item #1 { Color: Yellow, Sprockets: 73 }, Category Item #2 { Color: Red, Sprockets: 5 }, Category Item #3 { Color: Purple, Sprockets: 11 } ] } } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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