Parse DateTime From FileName

Hi I'm trying to develop a utility to manage large sets of backup's:

I have my backups structured like:

D:\SQLBACKUP\NOFAULT2010\Datatbase\LOG\NOFAULT2010_Datatbase_LOG_20110906_182000.trn
D:\SQLBACKUP\NOFAULT2010\Datatbase\LOG\NOFAULT2010_Database_LOG_20110906_183000.trn

I can get rid of the static parts easily enough

Replace(@"D:\SQLB开发者_如何转开发ACKUP\NOFAULT2010\Datatbase\LOG\NOFAULT2010_Datatbase_LOG_", "").Replace(".trn", "");

How can I consistently parse this part 20110906_182000 ... I'm open to any other suggestions. Thanks My brain is on vacation today something terrible.

You can parse out hour, minutes, seconds, etc. with Substring() and then use new DateTime() to create an instance of the date class.

An alternative is to use DateTime.TryParseExact() (http://msdn.microsoft.com/en-us/library/ms131044.aspx)

Just extract the DateTime part of the filename and parse it.

var path = @"D:\SQLBACKUP\NOFAULT2010\Datatbase\LOG\NOFAULT2010_Datatbase_LOG_20110906_182000.trn";
var filename = Path.GetFileNameWithoutExtension(path);
                   // assuming you have a consistent format with a fixed length
var datetimePart = filename.Substring(filename.Length - 15);
var datetime = DateTime.ParseExact(
    datetimePart, "yyyyMMdd_HHmmss", System.Globalization.CultureInfo.InvariantCulture);

p.s., When working with path strings, always use the System.IO.Path class to manipulate them. Don't use regular string manipulation techniques.

For your case you don't actually need to use substring or string parsing.

        DateTime parsedFileDate;

        string FileFullPath = @"D:\SQLBACKUP\NOFAULT2010\Datatbase\LOG\NOFAULT2010_Database_LOG_20110906_183000.trn";
        string FileNameFormat = "'NOFAULT2010_Database_LOG_'yyyyMMdd_HHmmss'.trn'";

        DateTime.TryParseExact(Path.GetFileName(FileFullPath), FileNameFormat, null, System.Globalization.DateTimeStyles.None, out parsedFileDate);

        Console.WriteLine($"Parsed date: {parsedFileDate}");

        Console.ReadLine();