Help with Combining Content of Two files

pisang · #1 (**permalink**) 05-27-2009

I'm trying to combine it using awk but still can't figure it out. Here is the file.

cat file1.txt
Mr Smith

Mr John

Ms Linda

cat file2.txt
No 4 Jln Empat
Kuala Lumpur

No 213 Tmn Bunga
Kedah

No 1 Kampung Bukit
Malaysia

I want to combine this file1 and file2 so the output will be:

Mr Smith
No 4 Jln Empat
Kuala Lumpur

Mr John
No 213 Tmn Bunga
Kedah

Ms Linda
No 1 Kampung Bukit
Malaysia

Anybody please help me...

Franklin52 · #2 (**permalink**) 05-27-2009

Quote:

Originally Posted by pisang

I'm trying to combine it using awk but still can't figure it out.

Can you show us what you have tried with awk?

Regards

pisang · #3 (**permalink**) 05-27-2009

Quote:

Originally Posted by Franklin52

Can you show us what you have tried with awk?

Regards

I try this script, but it says "awk: fatal: can't open source file `BEGIN {"

script:
#!/bin/sh
DATA1=file1.txt
DATA2=file2.txt

awk -f 'BEGIN {
while ((getline < "'$DATA2'") > 0)
f2array[$2] = $1
OFS=","}

{if (f2array[$1])
print f2array[$1],$2,$3,$4,$5
}' $DATA1

Thanks for your time to read my thread Franklin

ghostdog74 · #4 (**permalink**) 05-27-2009

if you have Python

Code:

#!/usr/bin/env python
file1=open("file1").read().split("\n")
file1=[i for i in file1 if i.strip() !="" ]
file2=open("file2").read().split("\n\n")
for item in zip(file1,file2):
    print item[0],"\n",''.join(item[1]),"\n"

output

Code:

# ./test.py
Mr Smith
No 4 Jln Empat
Kuala Lumpur

Mr John
No 213 Tmn Bunga
Kedah

Ms Linda
No 1 Kampung Bukit
Malaysia

Franklin52 · #5 (**permalink**) 05-27-2009

Assuming the lines are not separated by a blanc line in your files:

Code:

awk '{
  print
  getline s < "file2.txt"; print s
  getline s < "file2.txt"; print s
  print ""
}' file1.txt

Regards

pisang · #6 (**permalink**) 05-27-2009

Quote:

Originally Posted by ghostdog74

if you have Python

Code:

#!/usr/bin/env python
file1=open("file1").read().split("\n")
file1=[i for i in file1 if i.strip() !="" ]
file2=open("file2").read().split("\n\n")
for item in zip(file1,file2):
    print item[0],"\n",''.join(item[1]),"\n"

output

Code:

# ./test.py
Mr Smith
No 4 Jln Empat
Kuala Lumpur

Mr John
No 213 Tmn Bunga
Kedah

Ms Linda
No 1 Kampung Bukit
Malaysia

Thanks Ghostdog!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Combining two files	hemangjani	Shell Programming and Scripting	7	06-13-2007 10:32 PM
Combining Two Files	stevefox	Shell Programming and Scripting	4	02-20-2006 05:09 AM
Combining Two Files	bat711	Shell Programming and Scripting	3	10-05-2005 01:26 PM
Combining files	Enda Martin	UNIX for Dummies Questions & Answers	2	07-20-2001 10:31 AM
combining files	apalex	UNIX for Dummies Questions & Answers	3	06-19-2001 09:49 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: