Reading flat file and generating tagged file

Hi,

I'm a c# newbie and wish to read an i/p flat file of the form:

A 1 2 10

B 4 10 0

C 10 3 0

C B A

After reading it I wish to generate a tagged file fo the format:

<SET>
<TAG tagID = 'A'>
.
.
</TAG>
</SET>

<SUB>
<SB sID = 'A' eID = 'B'/>
.
.

</SUB>

Now the SUB tagis filled up only if the cell-value in the read item is non-zero...i.e. there will be no entry as sID= B eID = A & sID = C and eID = A...

Could anyone please give me clues, urls on how to approach this?
Will XMLWriter be of anyhelp?

Appreciate your guidance,
Angkar

I can't give you any specific examples right now (away from compiler and all), but XMLTextWriter is a good first step. Look into WriteStartDocument, WriteStartElement, WriteStartAttribute, WriteEndDocument, WriteEndElement, and WriteEndAttribute.

Here's an example:

Code:

class Program { static void Main(string[] args) { using (XmlTextWriter xmlWriter = new XmlTextWriter("test.xml", Encoding.Unicode)) { xmlWriter.WriteStartDocument(); //Make sure to enclose all tags in one top-level tag xmlWriter.WriteStartElement("Body"); xmlWriter.WriteStartElement("Tag1"); xmlWriter.WriteAttributeString("Attr1", "AttrValue1"); xmlWriter.WriteAttributeString("Attr2", "AttrValue2"); xmlWriter.WriteValue("Value1"); xmlWriter.WriteEndElement(); //</Tag1> xmlWriter.WriteStartElement("Tag2"); xmlWriter.WriteAttributeString("Attr1", "AttrValue1"); xmlWriter.WriteAttributeString("Attr2", "AttrValue2"); xmlWriter.WriteValue("Value2"); xmlWriter.WriteEndElement(); //</Tag2> xmlWriter.WriteEndElement(); //</Body> xmlWriter.WriteEndDocument(); } } }

Output:

Code:

<?xml version="1.0" encoding="utf-16"?> <Body> <Tag1 Attr1="AttrValue1" Attr2="AttrValue2">Value1</Tag1> <Tag2 Attr1="AttrValue1" Attr2="AttrValue2">Value2</Tag2> </Body>

Thank you so much. But you didn't mention how to read the file and store the values.
Appreciate your help.

To read a file, just use a StreamReader. How you read the data from the string returned by the Read methods depends on the data. The following example reads a comma-delimited file of numbers:

Code:

class Program { static void Main(string[] args) { string[] elements; List<List<int>> data = new List<List<int>>(); using (StreamReader reader = new StreamReader("test.csv")) { do { elements = reader.ReadLine().Split(','); data.Add(new List<int>()); foreach (string element in elements) { if(element.Length > 0) data[data.Count - 1].Add(int.Parse(element)); } } while (!reader.EndOfStream); } foreach(List<int> list in data) { foreach (int item in list) { if (item < 10) { Console.Write(string.Format(" {0} ", item.ToString())); } else Console.Write(string.Format("{0} ", item.ToString())); } Console.WriteLine(); } Console.ReadLine(); } }