Sample code on how to implement definite value reading from text files

Question

0.00/5 (No votes)

See more:

Hi Sir,

Good day!

I wanted to ask for a sample code in C# console application, on how could I implement the following scenario.

Sample Scene:
(input came from a text file) (output in a text file also)
I have three animals (CAT, DOG, MOUSE), the user needs to give a name on cat, dog and mouse in a several numbers (unknown numbers), plus they are differentiated on particular colors like BLACK, WHITE, BROWN. And count the number of particular animals based on their names and colors. (eg. class DOG, name: LASSIE, color: BLACK, WHITE and BROWN, Get Count: 5 Black Dogs found with a name of LASSIE, 3 White dogs found with a name of LASSIE, 2 Brown dogs found with a name of LASSIE)

Table example:
-----------------------------------------
ANIMALS NAMES BLACK WHITE BROWN
-----------------------------------------
CAT GARFIELD 2 1 5
CAT BELLA 1 4 3
CAT KITTA 7 9 6

DOG LASSIE 5 3 2
DOG SKITTER 2 1 4

MOUSE MOUSSY 1 3 5
MOUSE RATTY 3 6 9
MOUSE MIGHTY 6 2 2
MOUSE JIMM 1 0 1
-----------------------------------------
TOTAL: 28 26 37

The only fix variables are cat dog and mouse, and the color black white brown,
the unknown of definite value there are the names, the user can give different names and numbers.

Please Sir, I need your help on this.

Thanks in advance!

here's my sample code

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.IO;
namespace Clustering_Test
{
    class Program
    {
        static void Main(string[] args)
        {
            // Variable declaration (animal names)
            string strAnimal = String.Empty;
            string catName;
            int garfieldBlackCtr = 0, garfieldWhiteCtr = 0, garfieldBrownCtr = 0;
            int BellaBlackCtr = 0, BellaWhiteCtr = 0, BellaBrownCtr = 0;
            int KittaBlackCtr = 0, KittaWhiteCtr = 0, KittaBrownCtr = 0;
            int LassieBlackCtr = 0, LassieWhiteCtr = 0, LassieBrownCtr = 0;
            int SkitterBlackCtr = 0, SkitterWhiteCtr = 0, SkitterBrownCtr = 0;
            int MoussyBlackCtr = 0, MoussyWhiteCtr = 0, MoussyBrownCtr = 0;
            int RattyBlackCtr = 0, RattyWhiteCtr = 0, RattyBrownCtr = 0;
            string dogName, dogColorCtr;
            string mouseName, mouseColorCtr;
            string strGarfield, strBella, strKitta;
            string strLassie, strSkitter;
            string strMoussy, strRatty;
            // Reading input text file
            string dirFile = @"C:\FileDir\Sample_Text.txt";
            string recLine;
            int recCounter = 0;
            StreamReader srTable = new StreamReader(dirFile);
            while ((recLine = srTable.ReadLine()) != null)
            {
                recCounter++;
                strAnimal = recLine.Substring(0, 5);
                if (strAnimal == "CAT")
                {
                    // Get the name of the cat
                    catName = recLine.Substring(12, 9);
                    if (catName.Trim() == Cat.GARFIELD)
                    {
                        // Get the color count
                        string valCatColor = recLine.Substring(23, 3);
                        garfieldBlackCtr = Convert.ToInt32(valCatColor.Trim());
                        Process.intGarfieldBlack += garfieldBlackCtr;
                        string valCatColor2 = recLine.Substring(35, 3);
                        garfieldWhiteCtr = Convert.ToInt32(valCatColor.Trim());
                        Process.intGarfieldWhite += garfieldWhiteCtr;
                        string valCatColor3 = recLine.Substring(47, 3);
                        garfieldBrownCtr = Convert.ToInt32(valCatColor.Trim());
                        Process.intGarfieldBrown += garfieldBrownCtr;
                        // and so on...with BELLA and KITTA
                        // but the risk on this code, if new cat name occurred,
                        // I don't know how to handle new names and what variable counters
                        // could handle them...  please help me on this sir. thanks

                    }
                }
                else if (strAnimal == "DOG")
                {
                    // Get the name of the dog
                    dogName = recLine.Substring(12, 9);
                    if (dogName.Trim() == Dog.LASSIE)
                    {
                        // Get the color count
                        string valDogColor = recLine.Substring(23, 3);
                        LassieBlackCtr = Convert.ToInt32(valDogColor.Trim());
                        Process.intLassieBlack += LassieBlackCtr;
                        string valDogColor2 = recLine.Substring(35, 3);
                        LassieWhiteCtr = Convert.ToInt32(valDogColor.Trim());
                        Process.intLassieWhite += LassieWhiteCtr;
                        string valDogColor3 = recLine.Substring(47, 3);
                        LassieBrownCtr = Convert.ToInt32(valDogColor.Trim());
                        Process.intLassieBrown += LassieBrownCtr;
                        // and so on... with SKITTER
                        // but the risk on this code, if new cat name occurred,
                        // I don't know how to handle new names and what variable counters
                        // could handle them...  please help me on this sir. thanks
                    }
                    else if (strAnimal == "MOUSE")
                    {
                        // Get the color count
                        string valMouseColor = recLine.Substring(23, 3);
                        MoussyBlackCtr = Convert.ToInt32(valMouseColor.Trim());
                        Process.intMoussyBlack += MoussyBlackCtr;
                        string valMouseColor2 = recLine.Substring(35, 3);
                        MoussyWhiteCtr = Convert.ToInt32(valMouseColor.Trim());
                        Process.intMoussyWhite += MoussyWhiteCtr;
                        string valMouseColor3 = recLine.Substring(47, 3);
                        MoussyBrownCtr = Convert.ToInt32(valMouseColor.Trim());
                        Process.intMoussyBrown += MoussyBrownCtr;
                        // and so on...with RATTY
                        // but the risk on this code, if new cat name occurred,
                        // I don't know how to handle new names and what variable counters
                        // could handle them...  please help me on this sir. thanks
                    }
                }
                // Computer total count
                Process.intTotalBlack = Process.intGarfieldBlack + Process.intBellaBlack + Process.intKittaBlack +
                                                Process.intLassieBlack + Process.intSkitterBlack +
                                                Process.intMoussyBlack + Process.intRattyBlack;
                Process.intTotalWhite = Process.intGarfieldWhite + Process.intBellaWhite + Process.intKittaWhite +
                                             Process.intLassieWhite + Process.intSkitterWhite +
                                             Process.intMoussyWhite + Process.intRattyWhite;
                Process.intTotalBrown = Process.intGarfieldBrown + Process.intBellaBrown + Process.intKittaBrown +
                                             Process.intLassieBrown + Process.intSkitterBrown +
                                             Process.intMoussyBrown + Process.intRattyBrown;
            }
        }
    }
    class Cat
    {
        // I make the name constant to parallel it to text file which is wrong
        // because another names of cat might appear on text file like SMITTEN, KIM, CATTY
        public const string GARFIELD = "Garfield";
        public const string BELLA = "Bella";
        public const string KITTA = "Kitta";
    }
    class Dog
    {
        // I make the name constant to parallel it to text file which is wrong
        // because another names of dog might appear
        public const string LASSIE = "Lassie";
        public const string SKITTER = "Skitter";
    }
    class Mouse
    {
        // I make the name constant to parallel it to text file which is wrong
        // because another names of mouse might appear
        public const string MOUSSY = "Moussy";
        public const string RATTY = "Ratty";
        public const string MIGHTY = "Mighty";
        public const string JIMM = "Jimm";
    }
    class COLOR
    {
        public string BLACK = "Black";
        public string WHITE = "White";
        public string BROWN = "Brown";
    }
    class Process
    {
        // this variable assignment is wrong because another name of animals might occur and
        // no variable counter assigned to them... I need help on this too
        // Cat Variable Counters
        public static int intGarfieldBlack = 0;
        public static int intGarfieldBrown = 0;
        public static int intGarfieldWhite = 0;
        public static int intBellaBlack = 0;
        public static int intBellaBrown = 0;
        public static int intBellaWhite = 0;
        public static int intKittaBlack = 0;
        public static int intKittaBrown = 0;
        public static int intKittaWhite = 0;
        // Dog Variable Counters
        public static int intLassieBlack = 0;
        public static int intLassieBrown = 0;
        public static int intLassieWhite = 0;
        public static int intSkitterBlack = 0;
        public static int intSkitterBrown = 0;
        public static int intSkitterWhite = 0;
        // Mouse Variable Counters
        public static int intMoussyBlack = 0;
        public static int intMoussyBrown = 0;
        public static int intMoussyWhite = 0;
        public static int intRattyBlack = 0;
        public static int intRattyBrown = 0;
        public static int intRattyWhite = 0;
        // Total Counters
        public static int intTotalBlack = 0;
        public static int intTotalBrown = 0;
        public static int intTotalWhite = 0;
    }
}

Posted 11-May-11 23:22pm

Silver Lightning

Updated 12-May-11 20:37pm

v4

Add a Solution

Comments

OriginalGriff 12-May-11 5:27am

What have you tried?
Is this console, or Winforms, or web?
What file are you storing it in?
What classes have you got to play with?

Silver Lightning 12-May-11 21:15pm

pls help me sir

dan!sh 13-May-11 0:33am

OP has mentioned it is console application. :)

Oshtri Deka 12-May-11 5:34am

This is homework, right? Write something and I'll help when real problem appears.

Sandeep Mewara 12-May-11 6:27am

Any effort? I doubt... if so, share the same.

Silver Lightning 12-May-11 21:15pm

pls help me sir

Silver Lightning 12-May-11 20:25pm

Thank you sir, I tried to make a code but the name of the animal is hard coded which is wrong, because the user might be added new names and number value on it which is my primary problem (handling the animal names and number values in a flexible way)

I hope you could help me even a snip code

Thank you in advance.

Silver Lightning 12-May-11 20:58pm

it's console application, I'm reading a text file using the StreamReader and TextWriter like this one:

StreamReader file = new System.IO.StreamReader(CatchedFile, System.Text.Encoding.Default);
TextWriter tw = new StreamWriter(outFile, true, System.Text.Encoding.Default);

dan!sh 13-May-11 0:34am

It will be good if you can post the relevant code. This will show that you have tried and then you are stuck, rather than simply asking people to do your work.

Silver Lightning 13-May-11 2:36am

Hi Sir d@nish,

Here's my code...

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.IO;

namespace Clustering_Test
{
class Program
{
static void Main(string[] args)
{
// Variable declaration (animal names)
string strAnimal = String.Empty;
string catName;

int garfieldBlackCtr = 0, garfieldWhiteCtr = 0, garfieldBrownCtr = 0;
int BellaBlackCtr = 0, BellaWhiteCtr = 0, BellaBrownCtr = 0;
int KittaBlackCtr = 0, KittaWhiteCtr = 0, KittaBrownCtr = 0;

int LassieBlackCtr = 0, LassieWhiteCtr = 0, LassieBrownCtr = 0;
int SkitterBlackCtr = 0, SkitterWhiteCtr = 0, SkitterBrownCtr = 0;

int MoussyBlackCtr = 0, MoussyWhiteCtr = 0, MoussyBrownCtr = 0;
int RattyBlackCtr = 0, RattyWhiteCtr = 0, RattyBrownCtr = 0;

string dogName, dogColorCtr;
string mouseName, mouseColorCtr;

string strGarfield, strBella, strKitta;
string strLassie, strSkitter;
string strMoussy, strRatty;

// Reading input text file
string dirFile = @"C:\FileDir\Sample_Text.txt";
string recLine;
int recCounter = 0;

StreamReader srTable = new StreamReader(dirFile);
while ((recLine = srTable.ReadLine()) != null)
{
recCounter++;

strAnimal = recLine.Substring(0, 5);
if (strAnimal == "CAT")
{
// Get the name of the cat
catName = recLine.Substring(12, 9);
if (catName.Trim() == Cat.GARFIELD)
{
// Get the color count
string valCatColor = recLine.Substring(23, 3);
garfieldBlackCtr = Convert.ToInt32(valCatColor.Trim());
Process.intGarfieldBlack += garfieldBlackCtr;

string valCatColor2 = recLine.Substring(35, 3);
garfieldWhiteCtr = Convert.ToInt32(valCatColor.Trim());
Process.intGarfieldWhite += garfieldWhiteCtr;

string valCatColor3 = recLine.Substring(47, 3);
garfieldBrownCtr = Convert.ToInt32(valCatColor.Trim());
Process.intGarfieldBrown += garfieldBrownCtr;

// and so on...with BELLA and KITTA

// but the risk on this code, if new cat name occurred,
// I don't know how to handle new names and what variable counters
// could handle them... please help me on this sir. thanks

}
}
else if (strAnimal == "DOG")
{
// Get the name of the dog
dogName = recLine.Substring(12, 9);
if (dogName.Trim() == Dog.LASSIE)
{
// Get the color count
string valDogColor = recLine.Substring(23, 3);
LassieBlackCtr = Convert.ToInt32(valDogColor.Trim());
Process.intLassieBlack += LassieBlackCtr;

string valDogColor2 = recLine.Substring(35, 3);
LassieWhiteCtr = Convert.ToInt32(valDogColor.Trim());
Process.intLassieWhite += LassieWhiteCtr;

string valDogColor3 = recLine.Substring(47, 3);
LassieBrownCtr = Convert.ToInt32(valDogColor.Trim());
Process.intLassieBrown += LassieBrownCtr;

// and so on... with SKITTER

// but the risk on this code, if new cat name occurred,
// I don't know how to handle new names and what variable cou

Programm3r 13-May-11 3:28am

Not to point out the obvious, but you have to think dynamically about the problem. Everything is hard coded and static.

Silver Lightning 13-May-11 3:41am

that's my problem sir, I'm thinking of ArrayList, but it only holds the name of animal values, how about the number values to parallel with them and handle them both.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fredrik Bornander · Accepted Answer · 2011-05-12T22:53:00

Consider using dictionaries to store the data parsed from the file, something like this might solve it for you:

C#

using System;
using System.Collections.Generic;
using System.IO;

namespace SocketSample
{
    class Program
    {
        private static void ParseLine(string line, IDictionary<string, IDictionary<string, IDictionary<string, int>>> animals)
        {
            if (line.Trim() == String.Empty)
                return;

            try
            {
                string[] parts = line.Split(' ');
                string animal = parts[0];
                string name = parts[1];
                int blacks = Convert.ToInt32(parts[2]);
                int whites = Convert.ToInt32(parts[3]);
                int browns = Convert.ToInt32(parts[4]);

                if (!animals.ContainsKey(animal))
                    animals[animal] = new Dictionary<string, IDictionary<string, int>>();

                if (!animals[animal].ContainsKey(name))
                {
                    animals[animal][name] = new Dictionary<string, int>();
                    animals[animal][name]["Black"] = 0;
                    animals[animal][name]["White"] = 0;
                    animals[animal][name]["Brown"] = 0;
                }

                animals[animal][name]["Black"] += blacks;
                animals[animal][name]["White"] += whites;
                animals[animal][name]["Brown"] += browns;
            }
            catch (Exception e)
            {
                Console.Error.WriteLine("Failed to parse line \"{0}\", {1}", line, e.Message);
            }
        }

        private static void Dump(IDictionary<string, IDictionary<string, IDictionary<string, int>>> animals)
        {
            foreach(string animal in animals.Keys)
            {
                foreach(string name in animals[animal].Keys)
                {
                    foreach(string color in animals[animal][name].Keys)
                    {
                        Console.WriteLine("There are {0} {1} {2} named {3}", animals[animal][name][color], color, animal, name);
                    }
                }
            }
        }

        public static void Main(string[] args)
        {
            IDictionary<string, IDictionary<string, IDictionary<string, int>>> animals = new Dictionary<string, IDictionary<string, IDictionary<string, int>>>();
            foreach (string line in File.ReadAllLines(@"your_input_file_here.txt"))
            {
                ParseLine(line, animals);
            }
            Dump(animals);
        }
    }
}

Note that this is just an example and a proper solution would verify things that are bound (such as animal types).

Hope this helps,
Fredrik