StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14733722
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-06T16:18:30.727
FavoriteCount
0
LastActivityDate
2013-02-06T19:11:44.250
LastEditDate
2013-02-06T19:11:44.250
LastEditorUserId
211627
OwnerUserId
211627
ParentId
14129999
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>You can do this with two regular expressions and a recursive function with <strong>one caveat</strong>: special characters must be escaped. From what I can see, <code>"="</code>, <code>"["</code> and <code>"]"</code> have special meaning, so you must insert a <code>"\"</code> before those characters if you want them to appear as part of your property value. Note that commas are not considered "special". A comma before a <code>"property="</code> string is ignored, but otherwise they are treated in no special way (and, in fact, are optional between properties).</p> <h2>Input</h2> <pre class="lang-text prettyprint-override"><code>ObjectType [ property1=value1,val\=value2 property2=value2 \[property2\=this is not an object\], property3= AnotherObjectType [property4=some value4]] </code></pre> <h2>Regular Expressions</h2> <p>The regex for discovering "complex" types (beginning with a type name followed by square brackets). The regex includes a mechanism for balancing square brackets to make sure that each open bracket is paired with a close bracket (so that the match does not end too soon or too late):</p> <pre class="lang-regex prettyprint-override"><code>^\s*(?<TypeName>\w+)\s*\[(?<Properties>([^\[\]]|\\\[|\\\]|(?<!\\)\[(?<Depth>)|(?<!\\)\](?<-Depth>))*(?(Depth)(?!)))\]\s*$ </code></pre> <p>The regex for discovering properties within a complex type. Note that this also includes balanced square brackets to ensure that the properties of a sub-complex type are not accidentally consumed by the parent.</p> <pre class="lang-regex prettyprint-override"><code>(?<PropertyName>\w+)\s*=\s*(?<PropertyValue>([^\[\]]|\\\[|\\\]|(?<!\\)\[(?<Depth>)|(?<!\\)\](?<-Depth>))*?(?(Depth)(?!))(?=$|(?<!\\)\]|,?\s*\w+\s*=)) </code></pre> <h2>Code</h2> <pre><code>private static Regex ComplexTypeRegex = new Regex( @"^\s*(?<TypeName>\w+)\s*\[(?<Properties>([^\[\]]|\\\[|\\\]|(?<!\\)\[(?<Depth>)|(?<!\\)\](?<-Depth>))*(?(Depth)(?!)))\]\s*$" ); private static Regex PropertyRegex = new Regex( @"(?<PropertyName>\w+)\s*=\s*(?<PropertyValue>([^\[\]]|\\\[|\\\]|(?<!\\)\[(?<Depth>)|(?<!\\)\](?<-Depth>))*?(?(Depth)(?!))(?=$|(?<!\\)\]|,?\s*\w+\s*=))" ); private static string Input = @"ObjectType" + "\n" + @"[" + "\n" + @" property1=value1,val\=value2 " + "\n" + @" property2=value2 \[property2\=this is not an object\], property3=" + "\n" + @" AnotherObjectType [property4=some " + "\n" + @"value4]]"; static void Main( string[] args ) { Console.Write( Process( 0, Input ) ); Console.WriteLine( "\n\nPress any key..." ); Console.ReadKey( true ); } private static string Process( int level, string input ) { var l_complexMatch = ComplexTypeRegex.Match( input ); var l_indent = string.Join( "", Enumerable.Range( 0, level * 3 ).Select( i => " " ).ToArray() ); var l_output = new StringBuilder(); l_output.AppendLine( l_indent + l_complexMatch.Groups["TypeName"].Value ); foreach ( var l_match in PropertyRegex.Matches( l_complexMatch.Groups["Properties"].Value ).Cast<Match>() ) { l_output.Append( l_indent + "@" + l_match.Groups["PropertyName"].Value + " = " ); var l_value = l_match.Groups["PropertyValue"].Value; if ( Regex.IsMatch( l_value, @"(?<!\\)\[" ) ) { l_output.AppendLine(); l_output.Append( Process( level + 1, l_value ) ); } else { l_output.AppendLine( "\"" + l_value + "\"" ); } } return l_output.ToString(); } </code></pre> <h2>Output</h2> <pre class="lang-text prettyprint-override"><code>ObjectType @property1 = "value1,val\=value2 " @property2 = "value2 \[property2\=this is not an object\]" @property3 = AnotherObjectType @property4 = "some value4" </code></pre> <hr> <p>If you cannot escape the delimiters, then I doubt even a human could parse such a string. For example, how would a human reliably know whether the value of property 3 should be considered a literal string or a complex type?</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POTokenizing with RegEx when delimiter can be in token
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJDB
UserOwnerUserId
1. USJDB
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. This table or related slice is empty.

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.