Clever Geek Handbook

How do I get the date from this string?

I have this line:

\tid <01CA4692.A44F1F3E@blah.blah.co.uk>; <b>Tue, 6 Oct 2009 15:38:16</b> +0100

and I want to extract the date (boldly) into a more convenient format, eg. 06-10-2009 15:38:16

What would be the best way to do this?

+2


source to share


3 answers


Regex might be overkill. Just split by ';', Trim()

and call Date.Parse(...)

, It even handles the Timezone offset for you.



using System;

namespace ConsoleImpersonate
{
    class Program
    {
        static void Main(string[] args)
        {

            string str = "\tid 01CA4692.A44F1F3E@blah.blah.co.uk; Tue, 6 Oct 2009 15:38:16 +0100";
            var trimmed = str.Split(';')[1].Trim();
            var x = DateTime.Parse(trimmed);

        }
    }
}
+11


source


You can try this code (with possible settings)



Regex regex = new Regex(
      ";(?<date>.+?)",
    RegexOptions.IgnoreCase
    | RegexOptions.CultureInvariant
    | RegexOptions.IgnorePatternWhitespace
    | RegexOptions.Compiled
    );

var dt=DateTime.Parse(regex.Match(inputString).Groups["date"].Value)
+3


source


It uses a regular expression to match the format. The date result is formatted as you specified.

string input = @"\tid 01CA4692.A44F1F3E@blah.blah.co.uk; Tue, 6 Oct 2009 15:38:16 +0100";
// to capture offset too, add "\s+\+\d+" at the end of the pattern below
string pattern = @"[A-Z]+,\s+\d+\s+[A-Z]+\s+\d{4}\s+(?:\d+:){2}\d{2}";
Match match = Regex.Match(input, pattern, RegexOptions.IgnoreCase);

if (match.Success)
{
    string result = match.Value.Dump();
    DateTime parsedDateTime;
    if (DateTime.TryParse(result, out parsedDateTime))
    {
        // successful parse, date is now in parsedDateTime
        Console.WriteLine(parsedDateTime.ToString("dd-MM-yyyy hh:mm:ss"));
    }
    else
    {
        // parse failed, throw exception
    }
}
else
{
    // match not found, do something, throw exception
}
+1


source






More articles:


All Articles