StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPython pattern matching
primarykey
Id
4227637
data
AcceptedAnswerId
4228766
AnswerCount
4
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-11-19T17:23:21.003
FavoriteCount
0
LastActivityDate
2010-11-20T00:19:09.140
LastEditDate
2010-11-20T00:19:09.140
LastEditorUserId
133416
OwnerUserId
133416
ParentId
0
PostTypeId
1
Score
2
ViewCount
708
LastEditorDisplayName
text
Body
I'm currently in the process of converting an old bash script of mine into a Python script with added functionality. I've been able to do most things, but I'm having a lot of trouble with Python pattern matching. In my previous script, I downloaded a web page and used sed to get the elemented I wanted. The matching was done like so (for one of the values I wanted): <pre><code>PM_NUMBER=`cat um.htm | LANG=sv_SE.iso88591 sed -n 's/.*ol.st.*pm.*count..\([0-9]*\).*/\1/p'` </code></pre> It would match the number wrapped in <code></code> after the phrase "olästa pm". The markup I'm running this against is: <pre><code><td style="padding-left: 11px;"> <a href="/abuse_list.php"> <img src="/gfx/abuse_unread.png" width="15" height="12" alt="" title="9 anmälningar" /> </a> </td> <td align="center"> <a class="page_login_text" href="/pm.php" title="Du har 3 olästa pm."> 3 </td> <td style="padding-left: 11px;" align="center"> <a class="page_login_text" href="/blogg_latest.php" title="Du har 1 ny bloggkommentar"> 1 </td> <td style="padding-left: 11px;" align="center"> <a class="page_login_text" href="/user_guestbook.php" title="Min gästbok"> 1 </td> <td style="padding-left: 11px;" align="center"> <a class="page_login_text" href="/forum.php?view=3" title="Du har 1 ny forumkommentar"> 1 </td> <td style="padding-left: 11px;" align="center"> <a class="page_login_text" href="/user_images.php?user_id=162005&func=display_new_comments" title="Du har 1 ny albumkommentar"> 1 </td> <td style="padding-left: 11px;" align="center"> <a class="page_login_text" href="/forum_favorites.php" title="Du har 2 uppdaterade trådar i &quot;bevakade trådar&quot;"> 2 </td> </code></pre> I'm hesitant to post this, because it seems like I'm asking for a lot, but could someone please help me with a way to parse this in Python? I've been pulling my hair trying to do this, but regular expressions and I just don't match (pardon the pun). I've spent the last couple of hours experimenting and reading the Python manual on regular expressions, but I can't seem to figure it out. Just to make it clear, what I need are 7 different expressions for matching the number within <code></code>. I need to, for example, be able to find the number of unread PMs ("olästa pm").
Tags
<python><regex>
Title
Python pattern matching
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTommy Brunn
UserOwnerUserId
1. USTommy Brunn
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POPython pattern matching
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POPython pattern matching
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COregular expressions and html does not match (pardon the pun)
 singulars
 PostPostId
 POPython pattern matching
 UserUserId
 USLie Ryan

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.