I have some files with same name but with different dates. Basically we are finding the files with most recent dates

The file patterns are

<FileNames><YYYYMMDD><FileExtension>

e.g. test_20100506.xls indicates

<FileNames> = test_
<YYYYMMDD> = 20100506
<FileExtension> = .xls

Now in the source folder, the files are

standardization_20100503.xls, standardization_20100504.xls, standardization_20100305.xls, replacement_20100505.xls

As can be seen that, standardization_.xls are 3 in numbers but replacement_.xls is only 1.

The output will be a list of file names whose content will be

standardization_20100504.xls and replacement_20100505.xls

Because among all the standardization_.xls is the most recent one and replacement_.xls is also the same.

I have tried with my own logic but somehow failed.

My idea is as under

private static void GetLatestFiles(ref List<FileInfo> validFiles)
        {
            List<FileInfo> validFilesTemp = new List<FileInfo>();
            for (int i = 0; i < validFiles.Count; i++)
            {
                for (int j = i+1; j < validFiles.Count; j++)
                {
                    string getFileTextX = ExtractText(validFiles[i].Name);
                    string getFileTextY = ExtractText(validFiles[j].Name);
                    if (getFileTextX == getFileTextY)
                    {
                        int getFileDatesX = Convert.ToInt32(ExtractNumbers(validFiles[i].Name));
                        int getFileDatesY = Convert.ToInt32(ExtractNumbers(validFiles[j].Name));

                        if (getFileDatesX > getFileDatesY)
                        {
                            validFilesTemp.Add(validFiles[i]);
                        }
                        else
                        {
                            validFilesTemp.Add(validFiles[j]);
                        }
                    }
                }
            }

            validFiles.Clear();
            validFiles = validFilesTemp;
        }

The ExtractNumbers is:

public static string ExtractNumbers(string expr)
        {
            return string.Join(null, System.Text.RegularExpressions.Regex.Split(expr, "[^\\d]"));
        }

and the ExtractText is

public static string ExtractText(string expr)
        {
            return string.Join(null, System.Text.RegularExpressions.Regex.Split(expr, "[\\d]"));
        }

I am using c#3.0 and framework 3.5

Help needed .. it's very urgent

Thanks .