StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6232548
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-06-03T20:51:24.913
FavoriteCount
0
LastActivityDate
2011-06-03T21:19:25.727
LastEditDate
2011-06-03T21:19:25.727
LastEditorUserId
755127
OwnerUserId
755127
ParentId
6120748
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Depending on the exact content and guarantee of format of a CSV file, for speed and ease, sometimes using <a href="http://msdn.microsoft.com/en-us/library/system.string.split%28v=vs.71%29.aspx" rel="nofollow"><code>split</code></a> on the <code>,</code> is the easiest and fastest way to parse the file. Your Name col includes a <code>,</code> that is not a delimiter, which adds a little bit of complication though it is still trivial to handle that case assuming the name always contains 1 <code>,</code>. There are libraries to parse CSV files, which can be useful. Assuming you don't need to handle all files that conform to the CSV spec I feel that they are overkill. With all that said you can use the following <a href="http://www.regular-expressions.info/dotnet.html" rel="nofollow">regular expression</a> to easily parse the CSV file with named groups for convince: <code>"(?<Name>[^"]+?)",(?<UserName>[^,]+?),(?<RowType>[^,]+?),(?<StartDate>[^,]+?),(?<StartTime>[^,]+?),(?<EndTime>[^,]+?),(?<EndDate>[^,]+?),(?<SegmentStartDate>[^,]+?),(?<Type>\w+)</code> That will create named capture groups that you can then use to output to your new CSV file like so: <pre><code>Dim ResultList As StringCollection = New StringCollection() Try Dim RegexObj As New Regex("""(?<Name>[^""]+?)"",(?<UserName>[^,]+?),(?<RowType>[^,]+?),(?<StartDate>[^,]+?),(?<StartTime>[^,]+?),(?<EndTime>[^,]+?),(?<EndDate>[^,]+?),(?<SegmentStartDate>[^,]+?),(?<Type>\w+)", RegexOptions.IgnoreCase) Dim MatchResult As Match = RegexObj.Match(SubjectString) While MatchResult.Success 'Append to new CSV file - MatchResult.Groups("groupname").Value 'Name = MatchResult.Groups("Name").Value 'Start Time = MatchResult.Groups("StartTime").Value 'End Time = MatchResult.Groups("EndTime").Value 'Etc... End While Catch ex As ArgumentException 'Syntax error in the regular expression End Try </code></pre> See <a href="http://msdn.microsoft.com/en-us/library/hs600312%28v=vs.71%29.aspx" rel="nofollow">.NET Framework Regular Expressions</a> on MSDN for more information.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow can I reformat a CSV file into a Google Calendar Format?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USdaalbert
UserOwnerUserId
1. USdaalbert
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
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.