How can one parse a unknown datetime format in c#

Question

I'm trying to write a XML parser for TV Schedule Pro (http://sourceforge.net/p/tvschedulerpro). One particular challenge is in Parsing the DateTime reported by the date elements.

According to the DTD file:

All dates and times in this DTD follow the same format, loosely based on ISO 8601. They can be 'YYYYMMDDhhmmss' or some initial substring, for example if you only know the year and month you can have 'YYYYMM'. You can also append a timezone to the end; if no explicit timezone is given, UTC is assumed. Examples: '200007281733 BST', '200209', '19880523083000 +0300'. (BST == +0100.)

This is challenging situation, where I initially thought about using DateTimeFormatInfo.GetAllDateTimePatterns and using DateTime.TryParseExact, the last line about the timezones and particular format with any delimiters make it impossible to use the above.

Is there a concise way to parse the above datetime specification or does one just need to keeping finding/adding various patterns to parse the strings as one finds them (looks like virtually endless combinations)

You can probably still use DateTime.TryParseExact, but you'll probably have to pull out the timezone information yourself prior to making the call. — Kevin DiTraglia, May 02 '14 at 18:03
Did you try using "YYYYMMDDhhmmss" as the pattern argument for DateTime.TryParseExact? — 1.618, May 02 '14 at 18:15
http://stackoverflow.com/questions/3025916/convert-string-value-format-of-yyyymmddhhmmss-to-c-sharp-datetime — 1.618, May 02 '14 at 18:22
Yes I thought about that but it won't catch all the possible formats as you can see from the DTD definition. I'm looking for inputs on the best way to handle this — rboy, May 02 '14 at 21:46

score 2 · Accepted Answer · answered May 02 '14 at 19:03

Well, you could probably do something like this, using the K format specifier (see Custom DateTime Format Strings for details):

public static DateTimeOffset parseIso8601CompactForm( string text )
{
  DateTimeStyles options = DateTimeStyles.AllowWhiteSpaces
                         | DateTimeStyles.AssumeLocal
                         ;
  DateTimeOffset value = DateTimeOffset.ParseExact( text , formats , CultureInfo.CurrentCulture , options ) ;
  return value ;
}
static readonly string[] formats =
{
  "yyyyMMddHHmmssK" , "yyyyMMddHHmmss" ,
  "yyyyMMddHHmmK"   , "yyyyMMddHHmm"   ,
  "yyyyMMddHHK"     , "yyyyMMddHH"     ,
  "yyyyMMddK"       , "yyyyMMdd"       ,
  "yyyyMMK"         , "yyyyMM"         ,
  "yyyyK"           , "yyyy"           ,
} ;

But you'll probably find something like this somewhat more performant:

public static DateTimeOffset parseIso8601CompactForm( string text )
{
  if ( string.IsNullOrEmpty(text) ) throw new ArgumentException("text") ;
  if ( string.Length < 4 ) throw new ArgumentException("text") ;

  int            YYYY  = text.Length >=  4 ? int.Parse(text.Substring(  0 , 4 ) ) : 1    ;
  int            MM    = text.Length >=  6 ? int.Parse(text.Substring(  4 , 2 ) ) : 1    ;
  int            DD    = text.Length >=  8 ? int.Parse(text.Substring(  6 , 2 ) ) : 1    ;
  int            hh    = text.Length >= 10 ? int.Parse(text.Substring(  8 , 2 ) ) : 0    ;
  int            mm    = text.Length >= 12 ? int.Parse(text.Substring( 10 , 2 ) ) : 0    ;
  int            ss    = text.Length >= 14 ? int.Parse(text.Substring( 12 , 2 ) ) : 0    ;
  string         tzid  = text.Length >  14 ? text.Substring(14).Trim()            : null ;
  TimeZoneInfo   tz    = TimeZoneInfo.FindSystemTimeZoneById( tzid ) ;
  DateTimeOffset value = new DateTimeOffset( YYYY , MM , DD , hh , mm , ss , tz.BaseUtcOffset ) ;
  return value ;
}

Though, I'm sure there's some oddities around dealing with the time zone/offset-from-UTC that I haven't properly considered and would have to be properly dealt with.

I'm thinking this is the best answer so far. Would this handle +0300 or BST in the string? — rboy, May 02 '14 at 21:49

UndeadBob · Answer 2 · 2014-05-02T22:23:59.993

0

Maybe try a variant of DateTime.TryParseExact(time, ["yyyyMMddHHmmss K", "yyyyMMddHHmmss zzz"] ...

Might not catch all of them, but search http://msdn.microsoft.com/en-us/library/8kb3ddd4%28v=vs.110%29.aspx#KSpecifier for more ideas.

edited May 02 '14 at 22:23

answered May 02 '14 at 18:26

UndeadBob

1,110
1
15
34

That's the whole issue, I can't think of a single format/method that will catch all of them as defined in the DTD file above – rboy May 02 '14 at 21:45
Well no, but can you not use the string[] overload? It will still be a one liner. – UndeadBob May 02 '14 at 22:22

How can one parse a unknown datetime format in c#

2 Answers2