read a text file and perform some calcuation

Thu, 11 Dec 2008 16:24:31 -0700

hi

I have a problem on how to read text from file and perform operations on it for example

i have this text file that include

//name-//sex---------//birth //m1//m2//m3

fofo, male, 1986, 67, 68, 69
momo, male, 1986, 99, 98, 100
Habs, female, 1988, 99, 100, 87
toto, male, 1989, 67, 68, 69
lolo, female, 1990, 89, 80, 87
soso, female, 1988, 99, 100, 83

I want to read it and get the following

avg m1 : //average of all m1
avg m2 : //average of all m2
avg m3 : //average of all m3
avg Male M1 : //average of all m1 for males only
avg Male M2 : //average of all m2 for males only
avg Male M3 : //average of all m3 for males only
avg Female M1 : //average of all m1 for females only
avg Female M2 : //average of all m2 for females only
avg Female M3 : //average of all m3 for females only

Its allwoed to use regular experssion and the system.IO

can any one help

Re: read a text file and perform some calcuation

Wed, 24 Dec 2008 15:36:59 -0700

Hey, assuming the text is always formatted that way you can use the following(using System.IO, System.Text.RegularExpressions, System.Collections.Generic) though you can do it while reading instead of sticking into a collection.
Code:

List<Person> people = new List<Person>();
StreamReader test = new StreamReader(new FileStream("C:\\test.txt", FileMode.OpenOrCreate, FileAccess.Read));
while (test.Peek() != -1)
{
    Regex reg = new Regex(", ");
    object[] details = reg.Split(test.ReadLine());
    Person newPerson = new Person((String)details[0], (String)details[1], int.Parse((string)details[2]), int.Parse((string)details[3]),
        int.Parse((string)details[4]), int.Parse((string)details[5]));
    people.Add(newPerson);
}
foreach (Person pers in people)
{
    System.Console.WriteLine(pers.name);
}

and the Person Class is:

public String name, sex;
public int birth, m1, m2, m3;

public Person(String name, String sex, int birth, int m1, int m2, int m3)
{
    this.name = name;
    this.sex = sex;
    this.birth = birth;
    this.m1 = m1;
    this.m2 = m2;
    this.m3 = m3;
}

The storage will allow you to do things with it after like sorting, searching, etc. In that last foreach you do w/e calculations you want - just have a variable(or several) initialized outside the loop to keep track.

'read a text file and perform some calcuation' Thread RSS Feed

read a text file and perform some calcuation

Re: read a text file and perform some calcuation