Avatar of columcusack
columcusackFlag for Ireland asked on

two .TXT files I need to merge and append

Hi There,

WINDOWS Environment but can use a UNIX machine if needs be.

I have two db dump text files I need to append and merge.

So, what I need to do is as follows.

I have an original DBDUMP text file with all the data I need to restore. Lets call that FILE A.  I will take another DBDUMP today and call that FILE B. This file will have a lot of the data from FILE A but not all and also some changed data from FILE A.

I need something to merge and append the two if you kno what I mean.

So I want to add all the new data from FILE B to FILE A plus append any changes from FILE B to FILE A.

Hope that is clear?

I have ultraedit if thats any use.  I need one single ouput text file with all the data from FILE A & FILE B in there.

Please please please help?



I need to
DatabasesMicrosoft DOSVisual Basic.NET

Avatar of undefined
Last Comment

8/22/2022 - Mon

Try this.

There is no example of the data so it is rather difficult to suggest a solution.
On a linux/unix system you could try using cmp filea fileb or comm filea fileb.

comm relies on the files being sorted.
Bill Bach

If these are both database dump files, then perhaps there is an easier way.
1) Create a new database identical to the first one.  Be sure to define a unique key, if possible, to eliminate duplication.
2) Import the data from FileB into the table.
3) Import the data from FileA into the table.  This should NOT import records that already exist, as they should be filtered out by the unique key.
4) Export the data back to a single file.

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy