Databases
StackOverflow2013
Postsdbo
PORecognize Dates In A String
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORecognize Dates In A String
    primarykey
    data
    text
    <p>I want a class something like this:</p> <pre><code>public interface IDateRecognizer { DateTime[] Recognize(string s); } </code></pre> <p>The dates might exist anywhere in the string and might be any format. For now, I could limit to U.S. culture formats. The dates would not be delimited in any way. They might have arbitrary amounts of whitespace between parts of the date. The ideas I have are:</p> <ul> <li>ANTLR </li> <li>Regex </li> <li>Hand rolled</li> </ul> <p>I have never used ANTLR, so I would be learning from scratch. I wonder if there are libraries or code samples out there that do something similar that could jump start me. Is ANTLR too heavy for such a narrow use?</p> <p>I have used Regex a lot before, but I hate it for all the reasons that most people hate it.</p> <p>I could certainly hand roll it but I'd rather not re-solve a solved problem.</p> <p>Suggestions? </p> <p><strong>UPDATE</strong>: Here is an example. Given this input:</p> <blockquote> <p>This is a date 11/3/63. Here is another one: November 03, 1963; and another one Nov 03, 63 and some more (11/03/1963). The dates could be in any U.S. format. They might have dashes like 11-2-1963 or weird extra whitespace inside like this: Nov&nbsp;&nbsp;&nbsp;3,&nbsp;&nbsp;&nbsp;1963, and even maybe the comma is missing like [Nov 3 63] but that's an edge case.</p> </blockquote> <p>The output should be an array of seven DateTimes. Each date would be the same: 11/03/1963 00:00:00.</p> <p><strong>UPDATE</strong>: I totally hand rolled this, and I am happy with the result. Instead of using Regex, I ended up using DateTime.TryParse with a custom DateTimeFormatInfo, which allows you to very easily fine tune what formats are allowed and also handling of 2 digit years. Performance is quite acceptable given that this is handled async. The tricky part was tokenizing and testing sets of adjacent tokens in an efficient way.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdoppelgreener
    1. USTim Scott
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORecognize Dates In A String
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PORecognize Dates In A String
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PORecognize Dates In A String
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload