Reading a text file in a table in C #

advertisements

This is an extract from a text file that needs to be proccessed. What needs to be done is the program must read in this text file and format it to a specfication. The problem is i do not have much experiance working with text files. This is the sample input file.

BSA      Security Definition - Operator Report  Type 28

NBC 3RD QUARTER PROFILE REVIEW 2010
________________________________________________________________________________        

Operator:                 ABAZ095
Number of entries:        149
User selection:           Selected Items        

________________________________________________________________________________        

Search Criteria :-

    Operator Name   = BT%
    Approval Status = Any
    Enable Status   = Any
    One-time Pwd    = Any
    Profiles        =
    Units           =
    Printers        =
    Terminals       =  

________________________________________________________________________________        

Operator ID           = BTA020          

Name                  = ASIA CHAMBEGA
Active profile        = User_Disabled
Enable status         = Disabled
Re-enable date        = 31/12/36 00:00:00
Approval status       = Approved
Last changed          = 21/07/10 07:34:30
Last sign-on          = 13/06/08 14:09:37
Calculated pwd        = BD
One-time password     = No
Assigned unit         = None            

Operator ID           = BTAC002         

Name                  = A KALATA (NBC)
Active profile        = User_Disabled
Enable status         = Disabled
Re-enable date        = 31/12/36 00:00:00
Approval status       = Approved
Last changed          = 31/05/10 14:04:41
Last sign-on          = n/a
Calculated pwd        = B9
One-time password     = No
Assigned unit         = None            

Operator ID           = BTAK000         

Name                  = AISHA KEJO
Active profile        = NLCB_R6.0_ACCESSCTRL
Active profile        = NLCB_R6.0_VERAUT_MBE
Enable status         = Enabled
Re-enable date        = n/a
Approval status       = Approved
Last changed          = 12/07/08 08:10:47
Last sign-on          = 19/07/08 08:08:58
Calculated pwd        = 8A
One-time password     = No
Assigned unit         = NLCB            

Operator ID           = BTAL001         

Name                  = AMANDUS LIPILI
Active profile        = User_Disabled
Enable status         = Disabled
Re-enable date        = 31/12/36 00:00:00
Approval status       = Approved
Last changed          = 01/07/10 08:39:03
Last sign-on          = 11/11/09 08:25:07
Calculated pwd        = 4B
One-time password     = No
Assigned unit         = None

When processed the output file should look as follows:

BTAK000, AISHA KEJO, NLCB_R6.0_ACCESSCTRL
BTAK000, AISHA KEJO, NLCB_R6.0_VERAUT_MBE

As you can see, all the data needs to be pulled in but only Operator ID, name and active profile needs to be output. Everytime operator id if found in the file, the result needs to be printed to a new line. If the user has more than 1 active profile, the operator id and name and profile must be outputted to a new line. If the user has a disabled profile the data must be ignored. As you can see from the example the first to units are ignored because they are disabled. The user with the enabled satatus is the example. As you can see with the output example.

My idea is to pull the data into an array but only output the operator id, name and profile. How do I do this?

This is what I have so far:

Console.WriteLine("Enter Input File Location: " + "\n");

            //Reads path specifed by the user for input.
            string t = File.ReadAllText(Console.ReadLine());

            //Splits file where there is an equals sign.
            t = t.Replace("=", "");
            //Removes all tabbed spaces.
            t = t.Replace("\t", "");
            //Removes any new lines.
            t = t.Replace("\n", ",");
            //Removes blank spaces.
            t = t.Replace(" ", "");
            //Removes the Underscore.
            t = t.Replace("_", "");

            //Removes any leading or trailing whitespaces.
            t = t.Trim(',');

            //Writes formatted file to a pre defined ouput file's location.
            File.WriteAllText(@"C:/3rd Quarter1.txt", t);

With a textreader you can read every line by calling the ReadLine method of TextReader.

You do this in a while(!textreader.EndOfFile)

For each line you can search for specific characters --> search for the = and do something with the text behind it.

You can also check if the line starts with Operator ID

Related Articles

Read a text file in a table

How would I go about reading a text file from a file on disk into an array in memory? Also, I noticed using ReadLn only shows the first line (seems kind of obvious, since it is ReadLn, but how would I go about reading the whole text document?) functi

read a text file in a table in c

What would be the most efficient method of reading a text file into a dynamic one-dimensional array? reallocing after every read char seems silly, reallocing after every read line doesn't seem much better. I would like to read the entire file into th

Read a text file in a table with OS X Javascript

I'm really struggling to find documentation on how to read a text file into an array using OS X Automation with Javascript. Here's what I have so far: var app = Application.currentApplication(); app.includeStandardAdditions = true; var myFile = "/Use

Read the text file as numbers (table)

I'm working with MATLAB GUI. So, I want users to browse their own table from their computer. When they have browsed, the full path will be written on the static text, and the table (that they browse) will be appeared. The problem is, the file; it rea

Reading a text file in a table in Java

I'm pretty new to Java (currently enrolled in my first programming class), so the answer to my question could be right in front of me. My goal is to read in a text file that reads as follows: 4563123,112211324135412 2312311,222121324135211 2312345,11

Read the text file in the table (Store only numeric data)

I'm trying to read specific values from the text file (below): Current Online Users: 0 Total User Logins: 0 Server Uptime: 0 day, 0 hour, 0 minute Downloaded Amount: 0.000 KB Uploaded Amount: 0.000 MB Downloaded Files: 0 Uploaded Files: 0 Download Ba

Read the text file in a table

I'm trying to read a textfile that I've edited with Vim into an array. The textfile is 30*50 and is composed of single digit numbers. I've been going crazy trying to get it to work, but I think I'm having issues due to newline characters. Here's what

Java: About reading the text file in the table

i want read txt file into array. In the array, how can i do that? data = new String[lines.size] i dont want to hard code 10 in the array. My code: BufferedReader abc = new BufferedReader(new FileReader(myfile)); String []data; data = new String[10];

Java: Reads a text file in a table

I've a txt file composed by two columns like this: Name1 _ Opt1 Name2 _ Opt2 Name3 _ Opt3 In each row there's a name, a tab delimiter, a _ and then another name; there are really many rows (about 150000) and i'm not even sure which one is the best co

c read a text file in the table line by line and print them

i have the following c# code snippet string[] lines = File.ReadAllLines(@"C:\test.txt"); for(int i=0; i<lines.Length; i++) Console.WriteLine(lines[i]); Can you help me to convert it to C. Thanks!If you plan to use Ansi Standard C, you'll need

C # Read the text file and print it in a table

I'm trying to read a text file and print out into a table. I want the output to be this But now I having different output var column1 = new List<string>(); var column2 = new List<string>(); var column3 = new List<string>(); using (var rd