Compare two files in different formats and get output

File A:

DATAFILE                  TABLESPACE                                            
------------------------- -------------------------                             
/dev/rprod_0032_011       D_EEM                                                 
/dev/rprod_0032_012       D_ESO_REF                                             
/dev/rprod_0032_013       D_FLEXTOOL                                            
/dev/rprod_0032_014       D_I18N                                                
/dev/rprod_0032_015       D_IQHEALTH                                            
/dev/rprod_0032_016       D_IQHOLAP                                             
/dev/rprod_0032_017       D_MAT_MGT_1                                           
/dev/rprod_0032_018       D_MAT_MGT_2                                           
/dev/rprod_0032_019       D_MEDNET                                              
/dev/rprod_0032_020       D_MICRO                                               
/dev/rprod_0032_021       D_MMC                                                 

DATAFILE                  TABLESPACE                                            
------------------------- -------------------------                             
/dev/rprod_0032_022       D_MMR                                                 
/dev/rprod_0032_023       D_MRNET                                               
/dev/rprod_0032_024       D_OMF                                                 
/dev/rprod_0032_025       D_OMF_BATCH                                           
/dev/rprod_0032_026       D_OMF_RAD                                             
/dev/rprod_0032_027       D_OMF_SM             
......

File B:

/dev/rprod_0032_000 | 32
/dev/rprod_0032_001 | 32
/dev/rprod_0032_002 | 32
/dev/rprod_0032_003 | 32
/dev/rprod_0032_004 | 32
/dev/rprod_0032_005 | 32
/dev/rprod_0032_006 | 32
/dev/rprod_0032_007 | 32
/dev/rprod_0032_008 | 32
/dev/rprod_0032_009 | 32
/dev/rprod_0032_010 | 32
/dev/rprod_0032_011 | 32
.....

I have two files to be compared to get the output of the differences.

File A has the additional headings and spaces, but File B has no headings and spaces.

File B has a lot more lists than File A. I need to know what datafiles (beginning with /dev/r*) of File B are not in File A.

Please advise.

Thank you

nawk 'FNR==NR {if (/^\//) f1[$1];next} !($1 in f1) {print $1}' fileA fileB
1 Like