C#

o0romeo0o wrote:

I do cannot change the file naming convention

o0romeo0o wrote:

How can I compare the each record against each other

name_yyyyMMdd_HHmm.extension

// string wrapper for filename format 'name_yyyyMMdd_HHmm.ext'
public class MyFileData
{
    private string fullname;

    public MyFileData(string fullname)
    {
        this.fullname = fullname;
    }

    public string Fullname
    {
        get { return fullname; }
    }
    public string Name
    {
        get { return fullname.Substring(0, fullname.IndexOf('_')); }
    }
    public DateTime DateTime
    {
        get { return DateTime.ParseExact(fullname.Substring(fullname.IndexOf('_') + 1, 13), "yyyyMMdd_HHmm", CultureInfo.InvariantCulture); }
    }
    public string Extension
    {
        get { return fullname.Substring(fullname.IndexOf(".") + 1); }
    }
}

dicFilesDT.Add(dateParts[1], (dateParts[1] + dateParts[2] ));

string[] files = Directory.GetFiles(S.ImportFolder);
Array.Sort(files);
int count=files.Length;
for(int i=1; i<=count; i++) {
    string curr=files[i-1];
    string next="_the_end_";
    if (i<count) next=files[i];
    if (strcmp(curr.Substring(0,curr.LastIndexOf('_')), next.Substring(0,next.LastIndexOf('_'))!=0) {
        // process or store curr as it is the last one of this date
    }
}

foreach(string abc in someList){
}//end look
string abc = "test";

for (int i = 0; i < tblApplications.Controls.Count; i++) { ... }