C# Converting file format.

dipesh subramanim

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

dipesh subramanim12y ago
Thanks lot!! It helped moving.
0
Vulpes12y ago
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.

0