C# Converting file format.

Question

Hi I have two pipe-delimited text files (say A.txt and B.txt). Below is A.txt file format a standard format (can think of as Universal Set) EmpId|FName|LName|Sex|DOB|SSN|TagId1|TagId2 Below is B.txt file (can think of Sub Set) with column and 2 records. SSN|LName|FName|DOB|Sex|EmpId 123|Barrat|Alanzon|1983|F|4455 678|Alexia|Timothy|1975|M|2222||baz I need to convert B.txt into A.txt format’s columns order. Expected result is: EmpId|FName|LName|Sex|DOB|SSN|TagId1|TagId2 4455|Alanzon|Barrat|F|1983|123||| 2222| Timothy | Alexia|M|1975|678||baz thanks!

Vulpes · Answer

OK try this code: using System; using System.IO; class Program { static void Main() { bool first = true; string line = null; string[] s = null; string[] t = new string[8]; string aHeading = \EmpId\|\FName\|\LName\|\Sex\|\DOB\|\SSN\|\TagId1\|\TagId2\; using (StreamReader sr = new StreamReader(b.txt)) { using (StreamWriter sw = new StreamWriter(a.txt)) { while ((line = sr.ReadLine()) != null) { if (first) { // skip heading in b.txt first = false; sw.WriteLine(aHeading); // write a.txt heading } else { s = line.Split('|'); t[0] = s[5]; t[1] = s[2]; t[2] = s[1]; t[3] = s[4]; t[4] = s[3]; t[5] = s[0]; t[6] = (s.Length > 6) ? s[6] : ; t[7] = (s.Length > 7) ? s[7] : ; sw.WriteLine(String.Join(|t)); } } } } } } The output file a.txt contains: EmpId|FName|LName|Sex|DOB|SSN|TagId1|TagId2 4455|Alanzon|Barrat|F|1983|123|| 2222|Timothy|Alexia|M|1975|678||baz Although you had 3 pipes at the end of the first data line in your example I think it should in fact be 2.

dipesh subramanim · Answer

Thanks lot!! It helped moving.