C#

var distinctFiles = from f in Directory.GetFiles(@"C:\My Files").AsEnumerable()
                    select new
                    {
                        FileName = f.Split(new Char[] { '_' })[1],
                        FullPath = f
                    };

foreach (var file in distinctFiles.Distinct())
{
      ....
    }

The only programmers that are better those C# programmers are those who code in 1's and 0's

Programm3r
My Blog: ^_^

private void WeeklyExpenses_Load(object sender, EventArgs e)
        {
           Outlook.NameSpace oNs;
           Outlook.MAPIFolder oFldr;

            int iAttachCnt;

            DirectoryInfo di = new DirectoryInfo(System.Environment.CurrentDirectory.ToString() + "\\centralexpenses\\" + DateTime.Now.ToString("yyMMdd") + "\\");
            if (!di.Exists)
            {
                di.Create();
            }
            string strPath = System.Environment.CurrentDirectory.ToString() + "\\centralexpenses\\" + DateTime.Now.ToString("yyMMdd") + "\\";
            //MessageBox.Show(strPath);
            try
            {
                String sClassComp = "IPM.Note";
                oOutlook = new Outlook.Application();
                
                oNs = oOutlook.GetNamespace("MAPI");
                //Outlook.Recipient rcFieldAudit = default(Outlook.Recipient);
                //rcFieldAudit = oNS.CreateRecipient("Administrator");
                //getting mail folder from inbox
                //oFldr = oNs.GetSharedDefaultFolder(rcFieldAudit, Outlook.OlDefaultFolders.olFolderInbox);
                oFldr = oNs.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);
                Outlook.Items newMailItems = null;
                Outlook.MailItem mailItem = null;
                Outlook.Attachments atmt = null;
                newMailItems = oFldr.Items.Restrict("[unread] = true");
                // loop over the new mails
                   
                foreach (object item in newMailItems)
                {
                    if (((Outlook.MailItem)item).MessageClass == sClassComp)
                    {
                        // cast from object to Outlook.MailItem
                        mailItem = (Outlook.MailItem)item;
                        if (mailItem.SenderEmailType == "EX")
                        {
                            string emailString = X4UMapi.GetMessageSenderAddress(mailItem.MAPIOBJECT).ToString();
                            int lastindex = emailString.LastIndexOf("=") + 1;
                            empEmail = emailString.Substring(emailString.LastIndexOf("=") + 1, ((emailString.Length - 1) - emailString.LastIndexOf("="))) + "@phfi.org";
                        }
                        else
                        {
                            empEmail = mailItem.SenderEmailAddress.ToString();
                        }

                        // loop over the attachments
                        iAttachCnt = mailItem.Attachments.Count;
                        if (mailItem.Subject.ToString().ToUpper().Contains("Weekly Expenses") && iAttachCnt != 0)
                        {
                            foreach (Outlook.Attachment attachment in mailItem.Attachments)
                            {
                                // get the attachment filename and determine the type
                                string filename = attachment.FileName.ToLower();

                                if (filename.EndsWith(".xls"))
                                {
                                    //Mark Mail as Read
                                    mailItem.UnRead = false;
                                    // save tempfile for printing
                                    filename = strPath + attachment.FileName;
                                    flName = attachment.FileName;
                                    // save the attachment
                                    attachment.SaveAsFile(filename);
                                    // release the COM object
                                    Marshal.ReleaseComObject(attachment);
                                    openandProcessExpenses(strPath, flName, empEmail);
                                    smMail.sendMail(empName, empEmail, errorDescription);
                                }
                            }
                        }
                        else
                        {
                            if (iAttachCnt == 0)
                            {
                                errorDescription = "The Mail Sent By You is Not a Valid Email for Processing The Centrally Incurred Expenses As It Does Not Contain Any Attachments";
                            }
                            smMail.sendMail(empName, empEmail, errorDescription);
                        }
                    }
                }

            }
            catch (System.Exception ex)
            {
                //Response.Write("Execption generated:" + ex.Message);
            }
            finally
            {
                GC.Collect();
                oFldr = null;
                oNs = null;
                oOutlook = null;
            }
        }