StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
13759651
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-12-07T08:44:32.917
FavoriteCount
0
LastActivityDate
2012-12-07T08:44:32.917
LastEditDate
LastEditorUserId
0
OwnerUserId
165216
ParentId
13754007
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Pyparsing is pretty tolerant of whitespace characters as you show here, so I'm surprised this is an issue. One problem that you do have is in your definition of <code>list_G</code>: <pre><code>list_G = delimitedList(Word(printables))('mlist') #grammar for list </code></pre> I get what you're trying to do here, but your list element expression has a key problem. <code>delimitedList(expr)</code> is a handy short-cut for <code>expr + ZeroOrMore(Suppress(',') + expr)</code>, but the list element expression you are using for <code>expr</code> is <code>Word(printables)</code>, a word-group of any non-whitespace character. Unfortunately, this includes ',', your list delimiter. When you pass your string "one,two,three" to this expression, <code>Word(printables)</code> will parse the whole thing before it ever looks for a delimiter: <pre><code>>>> list_G = delimitedList(Word(printables)) >>> print (list_G.parseString("one,two,three")) ['one,two,three'] </code></pre> You need a way to say "I want my word to be everything printable that is not a comma". In older versions of pyparsing, you had to do this yourself with something like: <pre><code>word_of_everything_except_a_comma = Word(''.join(c for c in printables if c != ',')) </code></pre> In version 1.5.6, I added an <code>excludeChars</code> argument to Word to simplify this. Now you can just write: <pre><code>word_of_everything_except_a_comma = Word(printables, excludeChars=',') </code></pre> With a word like this, you will get a proper 3-element list: <pre><code>>>> list_G = delimitedList(Word(printables, excludeChars=',')) >>> print (list_G.parseString("one,two,three")) ['one', 'two', 'three'] </code></pre> This may be the issue you were struggling with, as pyparsing will implicitly skip over the whitespace characters that you are stripping out: <pre><code>>>> s = "one, two\t\t,\n\n\t\t\t three" >>> print (s) one, two , three >>> print (list_G.parseString(s)) ['one', 'two', 'three'] </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUsing pyparsing to parse a list from a string with special characters
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USPaulMcG
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. COHi Paul, I was using the grammars for variables and numbers but decided to use `printables` for the post because it's cleaner (see the edited post). I've edited my orig post that have an example when things don't work. Hope you can take a look.
 singulars
 PostPostId
 PO
 UserUserId
 USVu Nguyen

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.