StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20107476
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-11-20T21:33:06.277
FavoriteCount
0
LastActivityDate
2013-11-20T22:47:47.123
LastEditDate
2013-11-20T22:47:47.123
LastEditorUserId
1393766
OwnerUserId
1393766
ParentId
20106330
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>You can first store your tokens in dynamic size component like <code>List</code>. To fill such list with your tokens you need to iterate over each character in your sentence and if it is not <code>,</code> that is inside quote then add it to tokenBuilder, but if that comma is outside quote then add current value of tokenBuilder to your tokenList. Here is example code. </p> <pre><code>String line = "\"start \\\"title\\\" end\", 10, 20, \"text\""; List<String> tokens = new ArrayList<>(); StringBuilder tokenBuilder = new StringBuilder(); boolean insideQuote = false; char ch, prev = ' '; for (int i = 0; i < line.length(); i++) { ch = line.charAt(i); if (ch == '"' && prev != '\\') {// normal " (without \ before) insideQuote = !insideQuote; // starts or ends quotation } // commas that are outside quote or last character in line // should invoke adding non-empty builder to list if (ch == ',' && !insideQuote || i == line.length() - 1) { if (tokenBuilder.length() > 0) { tokens.add(tokenBuilder.toString().trim()); tokenBuilder.delete(0, tokenBuilder.capacity()); } } // add every character to builder except \ that are inside // quotes and have " after it else if (!(ch == '\\' && i + 1 < line.length() && line.charAt(i + 1) == '"' && insideQuote)) { tokenBuilder.append(ch); } prev = ch;//in next loop previous character should be our current one } String[] array = tokens.toArray(new String[tokens.size()]); for (String s : array) System.out.println(">" + s); </code></pre> <p>Output:</p> <pre><code>>"start "title" end" >10 >20 >"text </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POescape character using indexOf()
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPshemo
UserOwnerUserId
1. USPshemo
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
  VTUndeletion
CommentsPostId
1. COthat's the problem that where can be a comma in the middle of the string and it should be considered as part of the string if its between double quotes.
  singulars
  PostPostId
  PO
  UserUserId
  USuser2542809
2. CO@user2542809 check my updated answer.
  singulars
  PostPostId
  PO
  UserUserId
  USPshemo

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.