Convert Flat Text file into XML

Question

How to convert a inbound Flat Text file into xml using vb.net my text file .txt file AK^ALASKA^0.0000000.0000001994010102 DC^DISTRICT OF COLUMBIA^0.0575000.0575001994100111 into XML like AK ALASKA 0.0000000.0000001994010102 DC DISTRICT OF COLUMBIA 0.0575000.0575001994100111 Help greatly appreciated Thanks!!!

aryaonmesh · Answer

Thanks!!! Man. You given me an idea i will workaround.

bilnaad · Answer

Whoops! Made a little mistake. Here is the good working version :) using System; namespace ConsoleTesting { class Start { static void Main(string[] args) { /* * string arrays for easy tag retrieval */ string[] states = new string[]{" " ," "}; string[] state = new string[]{" " ," "}; string[] ftag = new string[]{" " ," "}; string[] ttag = new string[]{" " ," "}; string[] stag = new string[]{" " ," "}; //putting all tags in a 2 dimensional array string[][] tags = new string[][]{states ,state ,ftag ,stag ,ttag}; /* * baseText for one . * I used a two dummy characters '^' at the beginning of the line. * I did this because we initialize the int i in the for loop * to 2. Because else we retreive the tag from the array * instead of */ string baseText = "^^AK^ALASKA^0.0000000.0000001994010102"; //split the baseText into a array. string[] baseParts = baseText.Split('^'); //beginning of the xmlText. So we enter the tag etc.. string xmlText = string.Empty; xmlText = tags[0][0] + "
"; xmlText += tags[1][0] + "
"; //iterate through the data and places it between the tags. for(int i = 2; i tag xmlText += tags[1][1] + "
"; xmlText += tags[0][1]; Console.WriteLine("-----------------------"); Console.WriteLine("Plain text was:"); Console.WriteLine("-----------------------"); Console.WriteLine(baseText); Console.WriteLine("
-----------------------"); Console.WriteLine("Converted to xml:"); Console.WriteLine("-----------------------"); Console.WriteLine(xmlText); Console.Read(); } } }

bilnaad · Answer

Here is something to look at. This little console app converts one string of plain text into xml. using System; namespace ConsoleTesting { class Start { static void Main(string[] args) { /* * string arrays for easy tag retrieval */ string[] states = new string[]{" " ," "}; string[] state = new string[]{" " ," "}; string[] ftag = new string[]{" " ," "}; string[] ttag = new string[]{" " ," "}; //putting all tags in a 2 dimensional array string[][] tags = new string[][]{states ,state ,ftag ,ttag}; /* * baseText for one . * I used a dummy character '1' at the beginning of the line. * I did this because we initialize the int i in the for loop * to 1. Because else we retreive the tag from the array * instead of */ string baseText = "1^AK^ALASKA^0.0000000.0000001994010102"; //split the baseText into a array. string[] baseParts = baseText.Split('^'); //beginning of the xmlText. So we enter the tag string xmlText = tags[0][0] + "
"; //iterate through the data and places it between the tags. for(int i = 1; i tag xmlText += tags[0][1]; Console.WriteLine("-----------------------"); Console.WriteLine("Plain text was:"); Console.WriteLine("-----------------------"); Console.WriteLine(baseText); Console.WriteLine("
-----------------------"); Console.WriteLine("Converted to xml:"); Console.WriteLine("-----------------------"); Console.WriteLine(xmlText); Console.Read(); } } } I hope this will help you further :) Good luck

aryaonmesh · Answer

How will you do in C#

bilnaad · Answer

If you would post this in a VB.NET forum you will get better responses then inhere I suppose :)

Convert Flat Text file into XML

Answers (5)