C# How to convert one file format to another format?

Question

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"

How to go about it?

Do you need to do this in a program you're writing Or are you looking for a tool that does this? What OS are you running? — Dour High Arch, Feb 24 '14 at 22:58
Why are there spaces around `Timothy` and `Alexia` in the output, when it's not in the input? There's no similar modification for `Alanzon` and `Barrat`. — Barmar, Feb 24 '14 at 23:01
Trying to write C# code. The spaces around Timothy and Alexia are typo. — user3348809, Feb 24 '14 at 23:10

score 1 · Accepted Answer · answered Feb 24 '14 at 23:00

1

Since the two formats are basically the same, except the columns are reordered, I would recommend just reading B.txt into a dictionary (with the column name as the key) and then printing this dictionary to a file, with the columns in the right order.

answered Feb 24 '14 at 23:00

Paul Manta

30,618
31
128
208

score 0 · Answer 2 · answered Feb 24 '14 at 23:03

0

awk -F'|' -v OFS='|' '{print $6, $3, $2, $5, $4, $1, $7, $8}' B.txt > A.txt

answered Feb 24 '14 at 23:03

Barmar

741,623
53
500
612

C# How to convert one file format to another format?

2 Answers2