CSV FILE How do I delete rows with a date that has passed

Question

c# Windows Form csv file CSV FILE How do I delete rows with a date that has passed (Filename)(Year)(Month)(Day) lemon.txt2014130 Apple.txt2014130 orange.txt2014130 thanks

izak izak · Answer

Manas Mohapatra Thanks for your response My English is not so good and maybe I was wrong explanation the question I want to delete a row if the - (Year)(Month)(Day)- old date from today Your answer works great if I put the exact date to be deleted The problem is that I do not know always what are the dates written in the file And if I write today's date is not erase the lines with the old date not so Clean code -:) I got to the situation where comparable dates but can not erase those lines with the old date private void Form1_Load(object sender EventArgs e) { using (StreamReader sr = new StreamReader(1.csv)) { string headerLine = sr.ReadLine(); String line; while (sr.Peek() != -1) // Just read the first line and do nothing with it... while ((line = sr.ReadLine()) != null) { string[] parts = line.Split(''); string day = parts[3]; string month = parts[2]; string year = parts[1]; string OldDate = (day + / + month + / + year); DateTime dt1 = DateTime.Parse(OldDate); DateTime dt2 = DateTime.Now; if (dt1.Date >= dt2.Date) { MessageBox.Show(dt1 +  still relevant ); } else { // ... MessageBox.Show(dt1 +  The date has passed can be deleted ); } }

Manas Mohapatra · Answer

Try with below code: List lines = new List (); string line; System.IO.StreamReader file = new System.IO.StreamReader(D:\csvFile.txt); while ((line = file.ReadLine()) != null) { lines.Add(line); } lines.RemoveAll(l => l.Contains(2014130)); file.Close(); After removing all filtered records you need to write back to csv file. Here is the code: using (System.IO.StreamWriter outfile = new System.IO.StreamWriter( D:\csvFile.txt) )) { outfile.Write(String.Join(System.Environment.NewLine lines.ToArray())); }