AIX

Hi

My requirement is as follows,

I have a input feed coming for X as

A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P;
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P;
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P;
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P;
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P;


any other feed coming from Y is as

A,B,C,D,1,2,E,F,G,H,I,J,3,4,5,K,L,M,6,7,8,N,O,P

Now I want to merge both the feed and make the output as
A,B,C,D,0,0,E,F,G,H,I,J,0,0,0,K,L,M,0,0,0,N,O,P X
A,B,C,D,1,2,E,F,G,H,I,J,3,4,5,K,L,M,6,7,8,N,O,P Y

Any suggestions......

Regards,
SM

As far as i can see the result consists only of the second feed with all the numerical values set to zero. Maybe i misunderstood your requirement.

To set all the fields consisting of numerical values to "0" use the following sed filter:

Code:

sed 's/[0-9][0-9]*,/0,/g'

I hope this helps.

By merge do you mean read in both lines and then sort the output horizontally?
Here is an awkward try:

Code:

awk '{
           FILENAME=="file1" { arr[FNR]=$0 }
           FILENAME=="file2" { arr[FNR]= arr[FNR] " " $0}
        }
        END for (in in arr) { print arr[i]} ' file1  file2 | \
while read str
do
 echo $str | tr " " "\n" | sort | tr "\n" " "
 echo
done  > newfile