StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5164598
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-03-02T07:28:50.157
FavoriteCount
0
LastActivityDate
2011-03-02T07:28:50.157
LastEditDate
LastEditorUserId
0
OwnerUserId
20670
ParentId
5149524
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
I've written a completely new answer, now that the problem is clarified: You can do this in a single regex. It is quite bulletproof, I think, but as you can see, it's not exactly self-explanatory, which is why I've commented it liberally. Hope it makes sense. You're lucky that .NET allows re-use of named capturing groups, otherwise you would have had to do this in several steps. <pre><code>resultString = Regex.Replace(subjectString, @"(?: # Either match... (?<before> # (and capture into backref <before>) (?=\w*\p{L}) # (as long as it contains at least one letter): \w+ # one or more alphanumeric characters, ) # (End of capturing group <before>). \. # then a literal dot, (?<after> # (now capture again, into backref <after>) (?=\w*\p{L}) # (as long as it contains at least one letter): \w+ # one or more alphanumeric characters. ) # (End of capturing group <after>) and end of match. | # Or: \[ # Match a literal [ (?<before> # (now capture into backref <before>) [^\]]+ # one or more characters except ] ) # (End of capturing group <before>). \]\.\[ # Match literal ].[ (?<after> # (capture into backref <after>) [^\]]+ # one or more characters except ] ) # (End of capturing group <after>). \] # Match a literal ] ) # End of alternation. The match is now finished, but (?= # only if the rest of the line matches either... [^']*$ # only non-quote characters | # or [^']*'[^']*' # contains an even number of quote characters [^']* # plus any number of non-quote characters $ # until the end of the line. ) # End of the lookahead assertion.", "[${before}|${after}]", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace); </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PORegular expression to find separator dots in formula
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USTim Pietzcker
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PORegular expression to find separator dots in formula
 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
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThis is perfect, exactly what I needed. I really appreciate all of the comments that explain how it works. Hopefully this will be helpful for others trying to learn regex. Thanks for all your help Tim.
 singulars
 PostPostId
 PO
 UserUserId
 USpolara

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.