how to Merge two text file?

Question

5.00/5 (1 vote)

See more:

Hello,
i want to merge two text file.but i failed to create logic.
my files are like
abc.txt:-
1|SD2|12345
2|SD2|23455
3|SD2|34564
4|SD3|12344
5|SD3|2345

second file
def.txt:-
1|SD2|5676
2|SD3|678978

Now i want to create a file on the basis of SD2 and SD3 field.
my final text would be like :-
final.txt
1|SD2|12345
2|SD2|23455
3|SD2|34564
4|SD2|5676
5|SD3|12344
6|SD3|2345
7|SD3|678978

if you get any idea then please response.
Thanks

Posted 2-Feb-12 20:33pm

204.sharma

Add a Solution

Comments

LanFanNinja 3-Feb-12 3:01am

Check my solution below (solution 4) hope it helps and let me know if it works for you.

5 solutions

Solution 5

Some alternative solution employing some IEnumerable<strin> extension methods plus some LINQ syntax:

Concat(), Aggregate()
from ... in ... let d = ... orderby d ascending select d

C#

public static void MergeFiles(string in1, string in2, string merge)
{
    var q = from t in File.ReadAllLines(in1).Concat(File.ReadAllLines(in2))
            let d = t.Substring(t.IndexOf('|')+1) orderby d ascending
            select d;
    using (StreamWriter w = new StreamWriter(merge))
        q.Aggregate(0, (a, d) => { w.WriteLine("{0}|{1}", ++a, d); return a; });
}

Create a query that returns all truncated lines of both files (stripped off initial "...|"), sorted.
process all lines and write to the stream, by counting the line number (the aggregation value).

Cheers

Andi

Posted 4-Feb-12 11:45am

Andreas Gieriet

Comments

BillWoodruff 4-Feb-12 20:01pm

+5 Great Linq example.

Andreas Gieriet 4-Feb-12 20:03pm

Thanks for your 5!

LanFanNinja 5-Feb-12 6:42am

+5 Very nice indeed!!

Andreas Gieriet 5-Feb-12 8:09am

Thanks for your 5!

Solution 1

Merge Two Files with C#
and more results on
Google

Posted 2-Feb-12 20:36pm

uspatel

Comments

BillWoodruff 4-Feb-12 20:03pm

There is more to this question than just concatenating two text files: they must be merged by sorting.

best, Bill

Solution 2

You mean lines contains "SD2" word will come first in created file?

If it is a case, you can do it but you will have to apply the logic for doing the same...

Step 1: You can read all the lines which contains SD2 from first file and write on new file.
Step 2: Read all the lines which contains SD2 from second file and write on new file.
Step 3: and so on...

Kindly update if you have any doubt...

Posted 2-Feb-12 20:45pm

jai000

Updated 2-Feb-12 20:46pm

v2

Solution 3

a single line in batch wud do it
open a text file
and copy the below line
copy textfilename.txt + textfilename.txt newfile.txt

if there r many textfiles then copy all text files to a folder.
create a .bat file in the same folder and copy the line below
copy /b *.txt newfile.txt

save it with .bat extension
double click it to execute it

i prefer this because this wud b fast

Posted 2-Feb-12 20:51pm

Silent Guardian

Comments

Andreas Gieriet 4-Feb-12 17:54pm

Well, the OP asks also to re-number the final file (see example text), and the entries should be grouped...

If you want to use shell, you might consider to use powershell, e.g.:

PS> $n = 0; cat *.txt | %{ $_ -replace '^\d+\|','' } | sort | %{ $n++; echo "$n|$_" } > res.txt

Andi

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

LanFanNinja · Accepted Answer · 2012-02-02T21:01:00

This or some variation of this should work for you.

C#

List<string[]> data = new List<string[]>();
data.Add(File.ReadAllLines("abc.txt"));
data.Add(File.ReadAllLines("def.txt"));
List<string> finalData = new List<string>();

for (int i = 0; i < data.Count; i++)
{
    for (int n = 0; n < data[i].Length; n++)
    {
        string[] temp = data[i][n].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
        finalData.Add(temp[1] + "|" + temp[2]);
    }
}

finalData.Sort();

using (StreamWriter writer = new StreamWriter("final.txt"))
{
    for (int i = 0; i < finalData.Count; i++)
    {
        writer.WriteLine((i + 1).ToString() + "|" + finalData[i]);
    }

    writer.Close();
}

how to Merge two text file?

5 solutions

Solution 4

Solution 5

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us