UNIX for Dummies Questions & Answers

Hi Gurus,
I have 2 files:
File1
Filename1 xx
Filename1 yy
Filename1 Total
Filename2 xx
Filename2 yy
Filename2 zz
Filename2 Total
Filename3 xx
Filename3 Total

and File2:
Filename1 10296 xxx Date: 09/01/08
Filename2 10296 xxx Date: 09/05/08
Filename3 10296 xxx Date: 09/08/08

I need to merge these 2 files for every section breaking at Total.
output is:
Filename1 xx
Filename1 yy
Filename1 Total 10296 xxx Date: 09/01/08
Filename2 xx
Filename2 yy
Filename2 zz
Filename2 Total 10296 xxx Date: 09/05/08
Filename3 xx
Filename3 Total 10296 xxx Date: 09/08/08

I am trying to use the paste cmd but was not successful..please help.

thx

Repeating values is also fine:

Filename1 xx 10296 xxx Date: 09/01/08
Filename1 yy 10296 xxx Date: 09/01/08
Filename1 Total 10296 xxx Date: 09/01/08
Filename2 xx
Filename2 yy 10296 xxx Date: 09/05/08
Filename2 zz 10296 xxx Date: 09/05/08
Filename2 Total 10296 xxx Date: 09/05/08
Filename3 xx 10296 xxx Date: 09/08/08
Filename3 Total 10296 xxx Date: 09/08/08

Search this site for NR==FNR

hi ..I couldnt find anything.. Most of them match two files based on key.. I need to take one line from file 2 and add to file 1 till a pattern is reched and then i need to get the 2nd line from file 2 and add it and so on ..

any help is appreciated..

thanks

if you have Python

Code:

d={}
for lines in open("file2"):
    lines=lines.strip().split(" ",1)
    d[lines[0]] = lines[1]
for lines in open("file1"):
    lines=lines.strip().split()
    if "Total" in lines[1]:
        print lines[0] , d[lines[0]]
    else:
        print ' '.join(lines)

output:

Code:

# ./test.py
Filename1 xx
Filename1 yy
Filename1 10296 xxx Date: 09/01/08
Filename2 xx
Filename2 yy
Filename2 zz
Filename2 10296 xxx Date: 09/05/08
Filename3 xx
Filename3 10296 xxx Date: 09/08/08

With AWK (use nawk or /usr/xpg4/bin/awk on Solaris):

Code:

awk 'NR == FNR { 
  t = $1
  sub(/[^ \t]* /, "")
  _[t] = $0
  next
  }
($1 in _ && /Total/ && $0 = $0 FS _[$1]) || 1
' file2 file1

thank you ghostdog74 and radoulov for the help..

I was able to use radoulov code and get the desired output.. Is it possible to just give me a two line expalination of the code. i really like to understand it.. ALso i want to have the data added repeating for every line. thank you so much!

Filename1 xx xxx Date: 09/01/08
Filename1 yy xxx Date: 09/01/08
Filename1 10296 xxx Date: 09/01/08
Filename2 xx xxx Date: 09/05/08
Filename2 yy xxx Date: 09/05/08
Filename2 zz xxx Date: 09/05/08
Filename2 10296 xxx Date: 09/05/08