Merging two files


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Merging two files
# 1  
Old 01-10-2008
Merging two files

Hi I have a requirement like this.

I have two files
This is how data1.txt looks:
EI3171280 38640658501 NENN2005-12-129999-12-312005-12-12HALL NANCY 344 CHENEY HIGHWAY TITUSVILLE FL32780-0000 N 1-1192515160
PI95000M 23326685801 NENN2005-12-121924-02-172005-12-12POLING EARL W 2600-26TH AVE PARKERSBURG WV26101-0000 N 1-1192669087
EI3212756 58007867001 NSNN2005-12-121936-09-192005-12-12CRUZ AIDA P.O. BOX 1295 KINGSHILL,ST. C VI00851 N 1-1193006037
EI3210432 05128396601 NENN2005-12-121933-04-132005-12-12NERKO ELEANORE 60-16-76TH ST ELMHURST NY11373-2417 N 1-1192833610
EI3206592 23560778101 NENN2005-12-121941-08-312005-12-12SLAUGHTER CARL G 452 EAST FAIRLAWN DRIVE COVINGTON VA24426-0000 N 1-1192854020
PI25802 04738568501 NENN2005-12-121947-09-272005-12-12VLECIDES CONSTANTINE 27 WIND HILL WAY HOLMDEL NJ07733-1134 N 1-1192966250
EI3209792 43224032301 NENN2005-12-121916-01-192005-12-12SIMPSON LOUISE E 1102 DALINE SPRINGDALE AR72764-0000 N 1-1192968873
NI2429593 76420731101 NSNN2005-12-121974-01-282005-12-12RAMIREZ PEDRO 414 W PENNSYLVANIA TUCSON AZ85714 N 1-1193264262
EI3309644 61719151504 NSNN2005-12-121999-02-232005-12-12SANDOVAL ANDRES 1727 ROSE AVE SANTA ROSA CA95407-0000 N 1-1193559416
EI3308928 43065868602 NENN2005-12-121968-03-022005-12-12MILLS SR JOHN D 906 HOGAN DR MURFREESBORO TN37128-0000 N 1-1193399232
EI3308972 46825707401 NENN2005-12-121985-03-082005-12-12LEFEVRE STEPHANIE 17175 WALNUT LANE SPIRIT LAKE IA51360-0000 N 1-1193538259
999999 ICARE 2005-12-13 000000011

Please copy it into notepad without wordwrap to have a proper view.
Smilie

Next data2.txt appears like this:

JI3209792 43224032301 NENN2005-12-121916-01-192005-12-12SIMPSON LOUISE E 1102 DALINE SPRINGDALE AR72764-0000 N 1-1192968873
NI2429593 76420731101 NSNN2005-12-121974-01-282005-12-12RAMIREZ PEDRO 414 W PENNSYLVANIA TUCSON AZ85714 N 1-1193264262
JI3309644 61719151504 NSNN2005-12-121999-02-232005-12-12SANDOVAL ANDRES 1727 ROSE AVE SANTA ROSA CA95407-0000 N 1-1193559416
JI3308928 43065868602 NENN2005-12-121968-03-022005-12-12MILLS SR JOHN D 906 HOGAN DR MURFREESBORO TN37128-0000 N 1-1193399232
JI3308972 46825707401 NENN2005-12-121985-03-082005-12-12LEFEVRE STEPHANIE 17175 WALNUT LANE SPIRIT LAKE IA51360-0000 N 1-1193538259
999999 ICARE 2005-12-13 000000005

So the lines marked in the two files indicates the line count for each file. for the first file its 11 and for the next one its five. This is a common field for both the files.
Now what i need is to merge these two files like this

EI3171280 38640658501 NENN2005-12-129999-12-312005-12-12HALL NANCY 344 CHENEY HIGHWAY TITUSVILLE FL32780-0000 N 1-1192515160
PI95000M 23326685801 NENN2005-12-121924-02-172005-12-12POLING EARL W 2600-26TH AVE PARKERSBURG WV26101-0000 N 1-1192669087
EI3212756 58007867001 NSNN2005-12-121936-09-192005-12-12CRUZ AIDA P.O. BOX 1295 KINGSHILL,ST. C VI00851 N 1-1193006037
EI3210432 05128396601 NENN2005-12-121933-04-132005-12-12NERKO ELEANORE 60-16-76TH ST ELMHURST NY11373-2417 N 1-1192833610
EI3206592 23560778101 NENN2005-12-121941-08-312005-12-12SLAUGHTER CARL G 452 EAST FAIRLAWN DRIVE COVINGTON VA24426-0000 N 1-1192854020
PI25802 04738568501 NENN2005-12-121947-09-272005-12-12VLECIDES CONSTANTINE 27 WIND HILL WAY HOLMDEL NJ07733-1134 N 1-1192966250
EI3209792 43224032301 NENN2005-12-121916-01-192005-12-12SIMPSON LOUISE E 1102 DALINE SPRINGDALE AR72764-0000 N 1-1192968873
NI2429593 76420731101 NSNN2005-12-121974-01-282005-12-12RAMIREZ PEDRO 414 W PENNSYLVANIA TUCSON AZ85714 N 1-1193264262
EI3309644 61719151504 NSNN2005-12-121999-02-232005-12-12SANDOVAL ANDRES 1727 ROSE AVE SANTA ROSA CA95407-0000 N 1-1193559416
EI3308928 43065868602 NENN2005-12-121968-03-022005-12-12MILLS SR JOHN D 906 HOGAN DR MURFREESBORO TN37128-0000 N 1-1193399232
EI3308972 46825707401 NENN2005-12-121985-03-082005-12-12LEFEVRE STEPHANIE 17175 WALNUT LANE SPIRIT LAKE IA51360-0000 N 1-1193538259
JI3209792 43224032301 NENN2005-12-121916-01-192005-12-12SIMPSON LOUISE E 1102 DALINE SPRINGDALE AR72764-0000 N 1-1192968873
NI2429593 76420731101 NSNN2005-12-121974-01-282005-12-12RAMIREZ PEDRO 414 W PENNSYLVANIA TUCSON AZ85714 N 1-1193264262
JI3309644 61719151504 NSNN2005-12-121999-02-232005-12-12SANDOVAL ANDRES 1727 ROSE AVE SANTA ROSA CA95407-0000 N 1-1193559416
JI3308928 43065868602 NENN2005-12-121968-03-022005-12-12MILLS SR JOHN D 906 HOGAN DR MURFREESBORO TN37128-0000 N 1-1193399232
JI3308972 46825707401 NENN2005-12-121985-03-082005-12-12LEFEVRE STEPHANIE 17175 WALNUT LANE SPIRIT LAKE IA51360-0000 N 1-1193538259
999999 ICARE 2005-12-13 000000016

with the count for the merged file changed to 16 now. This is all i need..could you please help me with this.. am very naive in this..
please advise..
thanks

Last edited by venommaker; 01-10-2008 at 08:13 AM..
# 2  
Old 01-10-2008
paste first_file second_file > third_file

cat third_file
# 3  
Old 01-10-2008
hi thana,
this will create a duplicate entry of this line
999999 ICARE 2005-12-13 000000005

but i need only entry with an updated count also..your suggestion will just merge them..wont increase the line count!!
# 4  
Old 01-10-2008
You could use the uniq command for this.
# 5  
Old 01-10-2008
could you tell me exactly how to do this?? i am pretty new to this whole unix stuff!!
thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging two files

Hi All , I have a scenario where we need to combine two files . Below are the sample files and expected output , File 1: 1|ab 1|ac 1|ae 2|ad 2|ac File 2: 1|xy 1|fc 2|gh 2|ku Output file : 1|ab|xy (3 Replies)
Discussion started by: saj
3 Replies

2. Shell Programming and Scripting

Merging two files

Guys, I am having little problem with getting a daily report! The daily process that I do is as follows 1. Unload Header for the report from the systables to one unl file, say Header.unl 2. Unload the data from the required table/tables to another unl file, say Data.unl 3. Send a... (2 Replies)
Discussion started by: PikK45
2 Replies

3. Shell Programming and Scripting

Help with merging 2 files into 1

::::::::: ::FileA:: ::::::::: A1-------A2--------A3---A4---A5-- ================================= AC5VXVLT-XX---------------------- B57E434--XXXX1-----MMMM-ZZZ--111- C325G20--XXXXX3----CCCC------3332 DC35S51--XXXXY1----DDDD------44X- DC35S52--XXXXY2----DDDD------44Y-... (5 Replies)
Discussion started by: lordsmiter
5 Replies

4. Shell Programming and Scripting

Merging files

I have two files file 1 containing x rows and 1 column file 2 containing x rows and 1 column I want to merge both the files and add a comma between the two eg plz guide (1 Reply)
Discussion started by: test_user
1 Replies

5. UNIX for Dummies Questions & Answers

Merging two files

Hi, I have two files a.txt and b.txt. a.txt 1 2 3 4 b.txt a b c d e I want to generate a file c.txt by merging these two file and the resultant file would contain c.txt 1 (4 Replies)
Discussion started by: siba.s.nayak
4 Replies

6. Shell Programming and Scripting

merging of files.

Hi, I want to merge the two files on the basis of columns like... file 1 Data Key A 12 B 13 file2 Data Value A A1 A A2 B B1 B B2 (5 Replies)
Discussion started by: clx
5 Replies

7. Shell Programming and Scripting

merging two files

Hi everyone, I have two files which will be exactly same at first. After sometime there will be inserts in one file. My problem is how to reflect these changes in second file also. I found out that any compare and merge utility would do the job like, GNU " sdiff " command. But the... (14 Replies)
Discussion started by: rameshonline
14 Replies

8. Shell Programming and Scripting

Help with merging files

i would like to merge two files that have the same format but have different data. i would like to create one output file that contains information from both the original files.:rolleyes: (2 Replies)
Discussion started by: joe black
2 Replies

9. Shell Programming and Scripting

Merging 2 files

Hi, I have got two files 1.txt 1111|apple| 2222|orange| 2.txt 1111|1234|000000000004356| 1111|1234|000000001111| 1111|1234|002000011112| 2222|5678|000000002222| 2222|9102|000000002222| I need to merge these two so that my out put looks like below: Search code being used should be... (4 Replies)
Discussion started by: jisha
4 Replies

10. Shell Programming and Scripting

merging files

Thanks in advance I have 2 files having key field in each.I would like to join both on common key.I have used join but not sucessful. The files are attached here . what i Want in the output is on the key field SLS OFFR . I have used join commd but not successful. File one ======= SNO ... (6 Replies)
Discussion started by: vakharia Mahesh
6 Replies
Login or Register to Ask a Question