StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3703693
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-09-13T19:28:37.907
FavoriteCount
0
LastActivityDate
2010-09-14T18:18:29.043
LastEditDate
2010-09-14T18:18:29.043
LastEditorUserId
59111
OwnerUserId
59111
ParentId
3702835
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<p>Parsing HTML with regex is not ideal. Others have suggested the HTML Agility Pack. However, if you can guarantee that your input is well-defined and you always know what to expect then using a regex is possible.</p> <p>If you can make that guarantee, read on. Otherwise you need to consider the other suggestions or define your input better. In fact, you should define your input better regardless because my answer makes a few assumptions. Some questions to consider:</p> <ul> <li>Will the HTML be on one line or multiple lines, separated by newline characters?</li> <li>Will the HTML always be in the form of <code><div>...<h2...>...</h2><h3...>...</h3></div></code>? Or can there be <code>h1-h6</code> tags?</li> <li>On top of the <code>hN</code> tags, will the date and number always be between the tags with <code>id-date</code> and <code>nr</code> values for the <code>id</code> attribute?</li> </ul> <p>Depending on the answers to these questions the pattern can change. The following code assumes each HTML fragment follows the structure you shared, that it will have an <code>h2</code> and <code>h3</code> with date and number, respectively, and that each tag will be on a new line. If you feed it different input it will likely break till the pattern matches your input's structure.</p> <pre><code>Dim input As String = "<div id=""div"">" & Environment.Newline & _ "<h2 id=""id-date"">09.09.2010</h2>" & Environment.Newline & _ "<h3 id=""nr"">000</h3>" & Environment.Newline & _ "</div>" Dim pattern As String = "<div[^>]+>.*?" & _ "<h2\sid=""id-date"">(?<Date>\d{2}\.\d{2}\.\d{4})</h2>.*?" & _ "<h3\sid=""nr"">(?<Number>\d+)</h3>.*?</div>" Dim m As Match = Regex.Match(input, pattern, RegexOptions.Singleline) If m.Success Then Dim actualDate As DateTime = DateTime.Parse(m.Groups("Date").Value) Dim actualNumber As Integer = Int32.Parse(m.Groups("Number").Value) Console.WriteLine("Parsed Date: " & m.Groups("Date").Value) Console.WriteLine("Actual Date: " & actualDate) Console.WriteLine("Parsed Number: " & m.Groups("Number").Value) Console.WriteLine("Actual Number: " & actualNumber) Else Console.WriteLine("No match!") End If </code></pre> <p>The pattern can be on one line but I broke it up for clarity. <code>RegexOptions.Singleline</code> is used to allow the <code>.</code> metacharacter to handle <code>\n</code> for newlines.</p> <p>You also said: </p> <blockquote> <p>Also and this will be in loop, meaning there are more div block needed to be parsed.</p> </blockquote> <p>Are you looping over separate strings? Or are you expecting multiple occurrences of the above HTML structure in a single string? If the former, the above code should be applied to each string. For the latter you'll want to use <a href="http://msdn.microsoft.com/en-us/library/b49yw9s8.aspx" rel="nofollow noreferrer"><code>Regex.Matches</code></a> and treat each <code>Match</code> result similarly to the above piece of code.</p> <hr> <p><strong>EDIT:</strong> here is some sample code to demonstrate parsing multiple occurrences.</p> <pre><code>Dim input As String = "<div id=""div"">" & Environment.Newline & _ "<h2 id=""id-date"">09.09.2010</h2>" & Environment.Newline & _ "<h3 id=""nr"">000</h3>" & Environment.Newline & _ "</div>" & _ "<div id=""div"">" & Environment.Newline & _ "<h2 id=""id-date"">09.14.2010</h2>" & Environment.Newline & _ "<h3 id=""nr"">123</h3>" & Environment.Newline & _ "</div>" Dim pattern As String = "<div[^>]+>.*?" & _ "<h2\sid=""id-date"">(?<Date>\d{2}\.\d{2}\.\d{4})</h2>.*?" & _ "<h3\sid=""nr"">(?<Number>\d+)</h3>.*?</div>" For Each m As Match In Regex.Matches(input, pattern, RegexOptions.Singleline) Dim actualDate As DateTime = DateTime.Parse(m.Groups("Date").Value) Dim actualNumber As Integer = Int32.Parse(m.Groups("Number").Value) Console.WriteLine("Parsed Date: " & m.Groups("Date").Value) Console.WriteLine("Actual Date: " & actualDate) Console.WriteLine("Parsed Number: " & m.Groups("Number").Value) Console.WriteLine("Actual Number: " & actualNumber) Next </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POuse RegEx to extract text between html tags
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAhmad Mageed
UserOwnerUserId
1. USAhmad Mageed
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POuse RegEx to extract text between html tags
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COYes, will be on separated lines, yes it will be with only div,h2,h3 ... yes will be exactly like that formatted....and yes this is a large string that contains multiple block of similar information ....
  singulars
  PostPostId
  PO
  UserUserId
  USAdrian
2. CO@Adrian: I've updated my answer to show how to handle multiple occurrences using the `Regex.Matches` method and a `For Each` loop.
  singulars
  PostPostId
  PO
  UserUserId
  USAhmad Mageed

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.