Text file formatting

Hello

I have the attached text file that I would like to reformat.

The new format of the text file must be :

00:17:32 - 342333
00:17:33 - 2343242394809848754533
00:17:34 - 908942859445345435345345345

As you can see I am only extracting the time and the largest PAR.
If a record contains PAR's of same length, choose any of them.
If a record is empty, dismiss it.

Thank you so much
RECORD 00001
2000/01/01 00:17:32
PAR 1: 1 
PAR 6:     
PAR 2:   
PAR 7:     
PAR 3:   
PAR 8:     
PAR 4:   
PAR 9:     
PAR 5:   
PAR 10:      
-----------------------
RECORD 00002
2000/01/01 00:17:33
PAR 1: 1 
PAR 6:     
PAR 2: 34242342342  
PAR 7:     
PAR 3:   
PAR 8: 55535328883    
PAR 4:   
PAR 9:     
PAR 5:   
PAR 10:      
-----------------------
RECORD 00003
2000/01/01 00:17:34
PAR 1:  
PAR 6:    
PAR 2:   
PAR 7:      
PAR 3:   
PAR 8:      
PAR 4:   
PAR 9:     
PAR 5:   
PAR 10:     
-----------------------

Open in new window

giberiskAsked:
Who is Participating?
 
wdosanjosConnect With a Mentor Commented:
Please try the following:

var istream = new StreamReader(new FileStream(@"c:\temp\infile.txt", FileMode.Open));
var ostream = new StreamWriter(new FileStream(@"c:\temp\outfile.txt", FileMode.Create));
int size = 0;
string time = "";
string par = "";

for (string line = istream.ReadLine(); line != null; line = istream.ReadLine())
{
	line = line.Trim();

	if (line != "-----------------------")
	{
		size += line.Length;
		
		if (line[4] == '/') // date
		{
			time = line.Substring(11);
		}
		else
		{
			var match = Regex.Match(line, @"(?<=^PAR\s\d+:\s).*$");

			if (match.Success && match.Length > par.Length)
			{
				par = match.Value;
			}
		}
	}
	else
	{	// end of record
		if (size >= 100)
		{
			ostream.WriteLine(time + " - " + par);
		}

		time = "";
		par = "";
		size = 0;
	}
}

istream.Close();
ostream.Close();

Open in new window

0
 
giberiskAuthor Commented:
Brilliant!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.