StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7737985
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-10-12T09:32:52.927
FavoriteCount
0
LastActivityDate
2011-10-12T09:50:23.550
LastEditDate
2011-10-12T09:50:23.550
LastEditorUserId
637853
OwnerUserId
637853
ParentId
7737946
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Try this expression: <code>(?>-?\d+(?:[\./]\d+)?)</code>, keep in mind that in Java strings you need to escape the backslashes, i.e. you'd get <code>"(?>-?\\d+(?:[\\./]\\d+)?)"</code> Here's a breakdown of the expression: <ol> <li>The encloseing <code>(?>...)</code> is an atomic group to prevent catastrophic backtracking. For simple or short strings it would work without as well.</li> <li><code>-?</code> a potential minus for negative numbers </li> <li><code>\d+</code> any sequence of digits (at least one)</li> <li><code>(?:[\./]\d+)?</code> an optional non-capturing group consisting of either a dot (note that you don't need to escape it here, it's just for consistency) or a slash followed by at least one more digit.</li> </ol> Update If you don't want to replace "numbers" like <code>.1234</code>, <code>1234.</code> <code>/1</code> or <code>5/</code> (a digit is missing either left or right), try this expression: <code>(?>(?<![\d\./])-?\d+(?:(?:[\./]\d+)|(?![\d\./])))</code> Here's a breakdown again: <ol> <li>The encloseing <code>(?>...)</code> is an atomic group to prevent catastrophic backtracking. For simple or short strings it would work without as well.</li> <li><code>(?<![\d\./])</code> the match must not directly follow a digit, dot or slash - note that the not follow a digit constraint is needed to match at the start of the number, otherwise you'd match <code>234</code> in <code>.1234</code></li> <li><code>-?</code> a potential minus for negative numbers </li> <li><code>\\d+</code> any sequence of digits (at least one)</li> <li><code>(?:(?:[\./]\d+)|(?![\d\./]))</code> the match must either have a dot or slash followed by at least one digit or must not be followed by a digit, dot or slash, this would match <code>1.0</code> but not <code>1.</code> - note that the not to be followed by a digit constraint is needed to prevent matching <code>123</code> in <code>1234.</code></li> </ol>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POjava Regex: replace all numerical values with one number
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USThomas
UserOwnerUserId
1. USThomas
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POjava Regex: replace all numerical values with one number
 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
CommentsPostId
1. COthanks. escaping the backslashes was an important tip!
 singulars
 PostPostId
 PO
 UserUserId
 USuser961627

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.