StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1457581
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-09-22T00:34:30.073
FavoriteCount
0
LastActivityDate
2009-09-22T00:34:30.073
LastEditDate
LastEditorUserId
0
OwnerUserId
99071
ParentId
1457537
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Find: <pre><code>(.+?),\s? </code></pre> Replace: <pre><code>\1\r </code></pre> I'm not sure what you meant by “wrap the open/close around the category” but if you mean that you want to wrap it in some sort of tag or link just add it to the replace. Replace: <pre><code><a href="http://example.com/">\1</a>\r </code></pre> Would give you <pre><code><a href="http://example.com/">Social web</a> <a href="http://example.com/">Email</a> <a href="http://example.com/">Twitter</a> </code></pre> Or get fancier with Replace: <pre><code><a href="http://example.com/tag/\1/">\1</a>\r </code></pre> Would give you <pre><code><a href="http://example.com/tag/Social web/">Social web</a> <a href="http://example.com/tag/Email/">Email</a> <a href="http://example.com/tag/Twitter/">Twitter</a> </code></pre> In that last example you may have a problem with the “Social web” URL having a space in it. I wouldn't recommend that, but I wanted to show you that you could use the \1 backreference more than once. The Grep reference in the BBEdit Manual is fantastic. Go to Help->User Manual and then Chapter 8. Learning how to use RegEx well will change your life. UPDATE Weird, when I first looked at this it didn't show me your full example. Based upon what I see now you should Find: <pre><code>(.+?),\s? </code></pre> Replace: <pre><code><dc:subject>\1</dc:subject>\r </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHelp with grep in BBEdit
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJCobb
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. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThank you crazyj! Works great on a single line, but I'm trying to cleanup an RSS file so the lines are part of a long document and I need to find those too. I can't seem to initiate a find on: <dc:subject>(.+?),\s?</dc:subject> To replace it with: <dc:subject>\1</dc:subject>\r Do you know how I would do that?
 singulars
 PostPostId
 PO
 UserUserId
 USEC.
2. COYou would need to escape the backslash in the closing tag like this `<dc:subject>(.+?),\s?<\/dc:subject>`
 singulars
 PostPostId
 PO
 UserUserId
 USJCobb

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.