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.

C# Converting file format.

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)