nawk -F: 'BEGIN { OFS=":"}
{
# ampersand always has lead and trail spaces eg " & "
amp=index($3,"&");
hub=substr($3,1,amp-2);
wife=substr($3,amp+2);
id=$1;

mr=index(hub,"Mr");
rev=index(hub,"Rev");
dr=index(hub,"Dr");
if ( mr == 0 && rev == 0 && dr == 0 ) {
   $1=id".1"
   $3=hub
   print $0
   $1=id".2"
   $3=wife
   print $0
   }
if ( mr != 0 && rev == 0 && dr == 0 ) {
   $1=id".1"
   mrs=index(wife,"Mrs")
   hub=substr(wife,mrs+4)
   $3=hub
   print $0
   $1=id".2"
   $3=wife
   print $0
   }
if ( mr == 0 && rev != 0 && dr == 0 ) {
   $1=id".1"
   $3=hub
   print $0
   $1=id".2"
   $3=wife
   print $0
   }
if ( mr == 0 && rev == 0 && dr != 0 ) {
   $1=id".1"
   $3=hub
   print $0
   $1=id".2"
   $3=wife
   print $0
   }
}'

