tags:

views:

4

answers:

0

I've got a bunch of old spreadsheet data with date fields. Sometimes I'm lucky enough to get the standard Excel date format, but other times a range of dates was entered, with little consistency in the format: some are 07/2-5/95, others 07/02/1995-07/05/1995, still others 7-2 & 5-95. Short of writing regular expressions and parse rules for the 500 or so different formats, is there some simpler method/already written library that would take care of the vast majority of them?