StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2774959
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-05-05T16:16:16.837
FavoriteCount
0
LastActivityDate
2010-05-05T18:23:14.410
LastEditDate
2010-05-05T18:23:14.410
LastEditorUserId
192801
OwnerUserId
192801
ParentId
2774058
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You say: <blockquote> The aim is to replace these with my own custom wrapped acronym tags in a ColdFusion application I'm writing. </blockquote> It sounds like using XSL might be more appropriate than regex to transform one tag into another. UPDATE: Just threw this together, it seems to work for simple cases: (NOTE: this will simply strip out the 'acronym' tags. You could use XSL to replace them with your own custom tags, but you didn't specify anything along those lines so I didn't get into that) XSL: <pre><code><?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="*[name() = 'acronym']" /> </xsl:stylesheet> </code></pre> Input: <pre><code><?xml version="1.0" encoding="UTF-8"?> <root> This is some test text about <acronym title="Incomplete Test Syndrome" class="CustomClass">ITS</acronym> for the **ITS** department. Also worth mentioning ABS as well I guess.ITS, This is some **ITS** test text about <acronym title="Incomplete Test Syndrome" class="GOTManager">ITS</acronym> for the ITS department. Also worth mentioning ABS as well I guess </root> </code></pre> Output: <pre><code><?xml version="1.0" encoding="UTF-8"?> This is some test text about for the **ITS** department. Also worth mentioning ABS as well I guess.ITS, This is some **ITS** test text about for the ITS department. Also worth mentioning ABS as well I guess </code></pre> UPDATE: You said: <blockquote> So in the first example I want it to ignore the wrapped ITS and give me the ITS at the end of the 1st sentence. In the second example I want it to return the ITS at the start of the 2nd sentence. </blockquote> This makes no sense. Your second example doesn't have "ITS" in the second sentence. I think what you meant was that the <code>**ITS**</code> is what you want to have extracted. The XSL sample I gave only strips the <code><acronym/></code> tags, but after that's done you can try to find the <code>ITS</code> at different points in the sentence and maybe for that a regex might be easy (this assumes that you're ONLY have to worry about the <code><acronym/></code> tags).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PORegular Expression find a phrase not inside an HTML tag
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USFrustratedWithFormsDesigner
UserOwnerUserId
1. USFrustratedWithFormsDesigner
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.