StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4389518
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-12-08T16:01:52.370
FavoriteCount
0
LastActivityDate
2010-12-08T16:39:27.360
LastEditDate
2017-05-23T11:55:27.533
LastEditorUserId
-1
OwnerUserId
91822
ParentId
4388365
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You could use the regular expression functions from the <a href="http://docs.python.org/library/re.html" rel="nofollow noreferrer">re</a> module. For example like this: <pre><code>import re pattern = re.compile(r"^Name=(.*)$", flags=re.MULTILINE) re.sub(pattern, "Name=%s" % replace_name, s) </code></pre> (The <code>re.MULTILINE</code> option makes <code>^</code> and <code>$</code> match the beginning and the end of a line, respectively, in addition to the beginning and the end of the string.) <hr> Edited to add: Based on your comments to <a href="https://stackoverflow.com/questions/4388365/replacing-variable-text-in-between-two-known-elements/4388401#4388401">Emil's answer</a>, it seems you are manipulating <a href="http://standards.freedesktop.org/desktop-entry-spec/latest/" rel="nofollow noreferrer">Desktop Entry</a> files. Their syntax seems to be quite close to that used by the <a href="http://docs.python.org/library/configparser.html" rel="nofollow noreferrer">ConfigParser</a> module (perhaps some differences in the case-sensitivity of section names, and the expectation that comments should be preserved across a parse/serialize cycle). An example: <pre><code>import ConfigParser parser = ConfigParser.RawConfigParser() parser.optionxform = str # make option names case sensitive parser.read("/etc/skel/examples.desktop") parser.set("Desktop Entry", "Name", replace_name) parser.write(open("modified.desktop", "w")) </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POReplacing variable text in between two known elements
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USJukka Matilainen
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POReplacing variable text in between two known elements
 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
CommentsPostId
1. COKiitos Jukka. Both examples work great. I noticed ConfigParser seems to remove all comments including the #!/usr/bin/env xdg-open line (Yikes!), but I'm just studying the module's docs now to see if I can figure what to do about it. ConfigParser looks very handy. I'm sure I'm going to have a lot of fun with this. Hyvää Joulua!
 singulars
 PostPostId
 PO
 UserUserId
 USLeke

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.