Create csv file from text file.

Question

Dear All we have text file which contains details for of email broadcast out to customers which has success and failure details like below Sample File ------------- Sending to: test1@gamil.com Queued: test2@gami.com Failed: test3@gamil.com - Error with sending recipients - Server says: 550 5.1.1 Recipient address rejected: User unknown - code:6 : RCPT Command Error. The current recipient was rejected by the mail server. If you know this is a good address then please make sure that you are using the proper mail server and authentication options for your current internet connection. Sent: test4@hotmail.com Sent: test5@hotmail.com ----------- we have many failures and success in this file . So in this we need to read only failure emails and reason with the keyword Failed and write into .csv file with 2 columns as sample below. like Sample email reason test1@gmail.com ***** thinking to read info from text file with failure keyword and store inside data table and convert data table into excel or csv file. but not sure how to read from text file all the info with keyword Failed. Looking for sample code or advice for this. Waiting for your valuable reply!!! Regards Muthu

Vulpes · Answer

Try this. Where the reason extends over multiple lines I've 'flattened' it into one line but have retained the dashes which start each line: using System; using System.IO; class Program { static void Main() { string line = null; string email = null; string reason = ; bool started = false; using(var sw = new StreamWriter(sample.csv)) { sw.WriteLine(email		 reason); using(var sr = new StreamReader(sample.txt)) { while((line = sr.ReadLine()) != null) { line = line.Trim(); if (line.Length == 0) { continue; } else if (line.StartsWith(Failed: )) { if(!started) { started = true; } else { sw.WriteLine({0}	{1} email reason); } email = line.Substring(8); reason = ; } else if(Char.IsUpper(line[0]) && started) { sw.WriteLine({0}	{1} email reason); started = false; } else if(line[0] == '-') { reason +=   + line; } } if (started) { sw.WriteLine({0}	{1} email reason); } } } } }