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 :)