Join columns from 2 files

Shell Programming and Scripting
1

Hello guys.

I need to join columns of Start Time and End time of 2 files.

The Examples is:

File 1

APPLICATION GROUP_NAME JOB_NAME ODATE STATUS START_TIME END_TIME ::

MODCMPDA EDPONLINE MC00A1700 071102 Ended OK 20071102 17:00:01

File 2

APPLICATION GROUP_NAME JOB_NAME ODATE STATUS START_TIME END_TIME ::

MODCMPDA EDPONLINE MC210A0701 071101 Ended OK 20071101 07:05:02 20071101 07:05:10

The result i'm expecting is :

APPLICATION GROUP_NAME JOB_NAME ODATE STATUS START_TIME END_TIME ::

MODCMPDA EDPONLINE MC210A0701 071101 Ended OK " date of file1" " hh:mm:ss of file 1 " hh:mm:ss of file2 "

Can someone give me an and ?

Thanks

2

Hi,

This one should be ok for you.

code:

awk '
{
if(NF==8)
{
	var1[$2]=$7
	var2[$2]=$8
}
else
{
$7=var1[$2]
$8=var2[$2]
$9=$10
NF=9
print
}
}' file1 file2
3

Hello.

Maybe i didn't explain well.

I want to put :

File 1

APPLICATION GROUP_NAME JOB_NAME ODATE STATUS START_TIME END_TIME ::

MODCMPDA EDPONLINE MC00A1700 071102 Ended OK 20071102 17:00:01 17:00:10

File 2

APPLICATION GROUP_NAME JOB_NAME ODATE STATUS START_TIME END_TIME ::

MODCMPDA EDPONLINE MC210A0701 071101 Ended OK 20071101 07:05:02 20071101 07:05:10

that means from file 1 i want to have an last file with FIELDS 1 to 7 with FIELD 10 from file2 .