Shell Programming and Scripting

TEXAS CALIFORNIA TEXAS
DALLAS CALIFORNIA CALIFORNIA DALLAS
DALLAS TEXAS TEXAS DALLAS
NEW YORK NEW YORk

TEXAS,TX
DALLAS,DA

TEXAS CALIFORNIA TX|Y
DALLAS CALIFORNIA CALIFORNIA DA|Y
DALLAS TX TEXAS DA|Y
NEW YORK NEW YORk

DALLAS TX TEXAS DA|Y

DALLAS TEXAS TX DA|Y

awk     'NR==FNR        {T[$1]=$2; next}
                        {for (i in T) if (2 <= gsub (i,"&")) {
                                gsub (i, T[i])
                                sub  (T[i], i)
                                $0=$0 "|Y"
                                gsub ("\|Y\|Y","|Y")
                                }
                        }
         1
        ' FS="," file2 file1
TEXAS CALIFORNIA TX|Y
DALLAS CALIFORNIA CALIFORNIA DA|Y
DALLAS TEXAS TX DA|Y
NEW YORK NEW YORk

Hi,
 
Thanks for looking into this. I corrected the output and here it is.

TEXAS CALIFORNIA TX|Y
DALLAS CALIFORNIA CALIFORNIA DA|Y
DALLAS TEXAS TX DA|Y
NEW YORK NEW YORk

Hi,

I just executed the script that you provided but iam getting wired output. see below.

|YT|YE|YX|YA|YS|Y |YC|YA|YL|YI|YF|YO|YR|YN|YI|YA|Y |YT|YX|Y||Y|Y                
|YD|YA|YL|YL|YA|YS|Y |YC|YA|YL|YI|YF|YO|YR|YN|YI|YA|Y |YC|YA|YL|YI|YF|YO|YR|YN|Y
I|YA|Y |YD|YA|Y||Y|Y                                                            
|YD|YA|YL|YL|YA|YS|Y |YT|YE|YX|YA|YS|Y |YT|YE|YX|YA|YS|Y |YD|YA|Y||Y|Y          
NEW YORK NEW YORk

awk     'NR==FNR        {T[$1]=$2; next}
                        {for (i in T) if (2 <= gsub (i,"&")) {
                                gsub (i, T[i])
                                sub  (T[i], i)
                                sub  ("[^Y]$", "&|Y")
                                }
                        }
         1
        ' FS="," file2 file1