how to merge selective content between files using awk?

skumre · #1 (**permalink**) 04-21-2009

Hello,

I'm new to awk. I've 2 files where H stands for header and T for trailer. The number following T gives the record count in a file.

file 1 looks like this:
H|A|B|C
1|2|3
1|2|4
2|3|5
T|3

file 2 looks like this:
H|A|B|C
4|5|6
7|8|9
T|2

Need to merge the above 2 files such that the new file looks like this:

H|A|B|C
1|2|3
1|2|4
2|3|5
4|5|6
7|8|9
T|5

Any help is greatly appreciated.

vgersh99 · #2 (**permalink**) 04-21-2009

Code:

nawk -F'|' '
NR==1
$1!="H" && $1!="T"
$1=="T" {tot+=$2}
END { print "T" OFS tot}' OFS='|' file1 file2

skumre · #3 (**permalink**) 04-22-2009

Thanks a bunch for your help.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Merge files of differrent size with one field common in both files using awk	shashi1982	Shell Programming and Scripting	2	03-03-2009 07:12 AM
how to merge these two files?	fedora	Shell Programming and Scripting	3	02-12-2008 06:45 PM
use of sed over cat to merge files	miwinter	UNIX for Advanced & Expert Users	2	11-28-2007 01:36 PM
How to merge files	lestat_ecuador	Shell Programming and Scripting	3	06-07-2007 06:45 AM
Is there any non graphical tool that make selective merge between text files?	umen	UNIX for Dummies Questions & Answers	3	08-25-2005 02:22 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: