awk, join or sed

jkl_jkl · #1 (**permalink**) 04-15-2008

Code:

$ cat file1
a:23:43
A
B
C
a:24:21
a:23:44
S
D
A
F
a:24:44
a:23:45
S
D
E
a:24:45

$ cat file2
a:23:53
T
B
E
W
a:24:53
a:23:54
S
W
F
a:24:54
a:23:56
Q
W
W
E
E
a:24:56

How can i join both the files such that one instance of file1 (from the line starting with a to the next line starting with a) then one instacne of file2(similar)..
The starting line "a" is always constant.

i.e. required output:

Code:

a:23:43
A
B
C
a:24:21
a:23:53
T
B
E
W
a:24:53
a:23:44
S
D
A
F
a:24:44
a:23:54
S
W
F
a:24:54
a:23:45
S
D
E
a:24:45
a:23:56
Q
W
W
E
E
a:24:56

I tried normal join, but no luck.

Please.

aigles · #2 (**permalink**) 04-15-2008

Try and adapt this awk program :

Code:

awk '
FNR==1 { occ=1 ; file++ ; blk="" ; cnt=0 }
{
   blk = blk (blk ? ORS : "") $0
}
/^a:/ {
   occ = 1-occ
   if (occ) {
      rec[++cnt, file] = blk
      if (maxr<cnt) maxr = cnt
      blk=""
      next
   }
}
END {
   for (r=1; r<=maxr; r++) {
      for (f=1; f<=file; f++) {
         print rec[r, f]
      }
   }
}
    ' file1 file2

Jean-Pierre.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
join two files	koti_rama	Shell Programming and Scripting	5	08-05-2008 04:20 AM
Join	jazz8146	UNIX for Dummies Questions & Answers	5	01-29-2008 11:42 AM
join (pls help on join command)	summer_cherry	Shell Programming and Scripting	1	12-31-2007 05:19 AM
Join help with -e option	Ken555	UNIX for Dummies Questions & Answers	2	08-21-2006 10:50 PM

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:


	Powered by