How to delete files based on timestamp embedded in file name

Question

I am filtering files to delete based on creation timestamp. The piece of code that uses file creation works fine except that these files have embedded timestamp that somehow is different from create time. This causes a bunch of files to be missed for deletion.

This is what I am currently using:

public static void DeleteLogFiles(string sPath, DateTime dtDate, int iLogFileRetention)
{
    try
    {
        (from f in new DirectoryInfo(sPath).GetFiles()
            where f.CreationTime < dtDate.Subtract(TimeSpan.FromDays(iLogFileRetention))
            select f
            ).ToList()
            .ForEach(f => f.Delete());
    }
    catch (Exception ex)
    {
    }
}

Timestamp embeddd in file name is formatted as MMddyyyyHHmmss.

ABCD_20240309000024.dat, but its last modified date is 03/12/2024

How do I modify the Linq statement above to use embedded timestamp rather than create/modified date?

where f.FileName ?????

Answer 1

Use the following helper method

static DateTime GetDateTime(string strTimestamp)
{
    // ABCD_20240309000024.dat
    string fileName = Path.GetFileNameWithoutExtension(strTimestamp);
    string[] parts = fileName.Split("_");
    string dateTimePart = parts[1];
    DateTime dateTime = DateTime.ParseExact(dateTimePart, "yyyyMMddFFFFFF", CultureInfo.InvariantCulture);
    return dateTime;
}

and change the Linq as follows:

(from f in new DirectoryInfo(sPath).GetFiles()
    where (f.CreationTime < dtDate.Subtract(TimeSpan.FromDays(iLogFileRetention))
    || GetDateTime(f.Name) < dtDate.Subtract(TimeSpan.FromDays(iLogFileRetention)))
    select f
    ).ToList()
    .ForEach(f => f.Delete());

Please note that I used the date time format yyyyMMdd and you might need to change this.