StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12831869
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-10-11T03:44:17.130
FavoriteCount
0
LastActivityDate
2012-10-11T03:44:17.130
LastEditDate
LastEditorUserId
0
OwnerUserId
108205
ParentId
12831602
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
What do you call "special characters"? What is the encoding of the data you have? Before proceeding, it is important for that you do understand what are encodings, what is unicode, and that the wrold, and data you get around is not restricted to the 26 letters primarily used in the English language. <a href="http://www.joelonsoftware.com/articles/Unicode.html" rel="nofollow">Check this article</a> to learn about it. That said, Python can encode your data in an encoding of your choice - even ASCII, so you only get the characters 32-127, and no "stranger" characters at all - like ã, ç, É - or you can encode your data in utf-8 to be able to use the whole array of characters we use around the planet. However, if you can only "encode" Unicode data (Python tries to implicit convert a byte string to unicode before if you use the encode string method) - so you do have to know the encoding of your data source anyway. Once your data is decoded into unicode (inside your running program), you can encode it to your desired output (e.g. ASCII or "quopri_codec" ), and set the "errors" keyword parameter to "ignore" or "xmlcharrefreplace" on your call to encode. To understand it better, check the <a href="http://docs.python.org/library/codecs.html" rel="nofollow">codecs documentation</a> from Python For example, assuming your input data is incoded in iso8859_15 (aka latin1 or cp1252 put or take 2 char definitions),a nd that you really mean to suppress any non-English character: <pre><code>s = client.service.GetData('data1') s = s.decode("iso88159_15").encode("ASCII", errors="ignore") sr = '<root>%s</root>' % s root = ET.fromstring(sr) </code></pre> Otoh, since you are encoding xml, putting xml references to the chars you don't want to deal with should not hurt - (as probably encoding to utf-8 would not hurt either): <pre><code>s = s.decode("iso88159_15").encode("ASCII", errors="xmlcharrefreplace") </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POFormatting/Displaying list in python
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USjsbueno
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. COThe special characters I'm referring is the characters in the list like [],', just want to extract the data itself in the list and put it in a text file. Thank you for your insight.
 singulars
 PostPostId
 PO
 UserUserId
 USMacky Carlos

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.