Text file reading

chava

Hi,

I have one text file having the data in the below format

AA| 12
BB | 15
CC| 10
AA|20
...
...
...
...

in this format first value(AA) is some name and second value (12) is count . so in my requirement i want to read that text file and want to check with the first column in the first line with all other lines in the first column ,if any match is found then the count of the first column shouuld be added to the match column's count.i.e.
AA in first line value is matched with fourth line first column then count of the first column will be 32 (12 +20).

please help me out for the solution,.

Thanks.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
Try this:

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

class Program
{
static void Main()
{
Dictionary dict = new Dictionary();
StreamReader sr = new StreamReader("padma.txt");
string line = null;
int count = 0;
while((line = sr.ReadLine()) != null)
{
line = line.Trim();
if (line == "") continue;
string[] items = line.Split('|');
string name = items[0].Trim();
int.TryParse(items[1], out count);
if(count == 0) continue;
if(dict.ContainsKey(name))
{
dict[name] += count;
}
else
{
dict.Add(name, count);
}
}
sr.Close();

// write back to new file
StreamWriter sw = new StreamWriter("padma2.txt");
foreach(string name in dict.Keys)
{
sw.WriteLine(String.Format("{0}|{1}", name, dict[name]));
}
sw.Close();
}
}
Vulpes15y ago
That's more complicated because if you're still going to add up the AA's etc, then presumably you're going to need a way of concatenating the 'Tests' and will also need to know what the number is for each Test.

I'd suggest writing a custom Record class to deal automatically with all this:

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

class Record
{
public string Name {get; private set;}
public List Numbers {get;private set;}
public List Descriptions {get;private set;}

public Record(string name, int number, string description)
{
Name = name;
Numbers = new List();
Descriptions = new List();
Numbers.Add(number);
Descriptions.Add(description);
}

public int Total
{
get
{
int total = 0;
foreach(int i in Numbers) total += i;
return total;
}
}

public string CombinedDescription
{
get
{
string[] items = new string[Descriptions.Count];
for(int i = 0; i < Descriptions.Count; i++)
{
items[i] = String.Format("{0}({1})", Descriptions[i], Numbers[i]);
}
return String.Join(",", items);
}
}

public override string ToString()
{
return String.Format("{0} | {1} | {2}", Name, Total, CombinedDescription);
}
}

class Program
{
static void Main()
{
Dictionary dict = new Dictionary();
StreamReader sr = new StreamReader("padma.txt");
string line = null;
int number;

while((line = sr.ReadLine()) != null)
{
line = line.Trim();
if (line == "") continue;
string[] items = line.Split('|');
if (items.Length != 3) continue; // something's wrong - ignore the lines
string name = items[0].Trim();
int.TryParse(items[1], out number);
if(number == 0) continue; // somethings' wrong - ignore the line
Record r;

if(dict.ContainsKey(name))
{
r = dict[name];
r.Numbers.Add(number);
r.Descriptions.Add(items[2]);
}
else
{
r = new Record(name, number, items[2]);
dict.Add(name, r);
}
}
sr.Close();

// write back to new file
StreamWriter sw = new StreamWriter("padma2.txt");
foreach(string name in dict.Keys)
{
sw.WriteLine(dict[name].ToString());
}
sw.Close();
}
}

The output for the sample file should be:

AA | 32 | Test(12),Test3(20)
BB | 15 | Test1(15)
CC | 10 | Test2(10)
chava15y ago
i need to read and write to the file one more column in the list
i.e, in the below format text i need to read ...
AA| 12|Test
BB | 15|Test1
CC| 10|Test2
AA|20 |Test3
then how should i proceede ?
chava15y ago
thank you .it's working fine for me.