StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POStrategies for finding dates or date/times in a text document?
primarykey
Id
7668569
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-10-05T22:36:40.383
FavoriteCount
0
LastActivityDate
2011-10-05T22:52:41.617
LastEditDate
LastEditorUserId
0
OwnerUserId
573695
ParentId
0
PostTypeId
1
Score
1
ViewCount
105
LastEditorDisplayName
text
Body
Problem: Given an unstructured text document find any date or date/time substrings. My current thoughts are to search for known formats with a bunch of regex's which feels grossly kludgy, expensive and prone to errors :-) This is the sort of doc I'm talking about: <blockquote> Bacon ipsum dolor sit amet sirloin reprehenderit spare ribs aute. Ullamco consequat shank swine chuck, laboris do pastrami January 10th 1980 est venison shankle short 1-20-1980 loin bresaola corned beef. Beef ribs 28/2/2001 tri-tip est cupidatat shank, excepteur qui non pastrami. </blockquote> I suspect I'm not the first person to address this problem, and I'm hoping that the resultant code is buried in some open source project I don't know about… Thoughts?
Tags
<parsing><datetime><date>
Title
Strategies for finding dates or date/times in a text document?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJohn Pettitt
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POStrategies for finding dates or date/times in a text document?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COWhat is wrong with using a regex to do this? Why do you think it would be kludgy and or expensive or prone to errors? This is what regex was made for...
 singulars
 PostPostId
 POStrategies for finding dates or date/times in a text document?
 UserUserId
 UShspain
2. COYour example has made me hungry.
 singulars
 PostPostId
 POStrategies for finding dates or date/times in a text document?
 UserUserId
 USspam_eggs

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.