Shell Programming and Scripting

TEXAS CALIFORNIA TEXAS
DALLAS CALIFORNIA CALIFORNIA DALLAS DALLAS TEXAS

TEXAS,TX
DALLAS,DA
CALIFORNIA,CA
NEWYORK,NY

TEXAS CALIFORNIA TX

DALLAS CALIFORNIA CALIFORNIA DA DA TEXAS

echo "Replace the string matches only once or except FIRST occurence replace ALL."
        
	tot_cnt=`wc -l < $REP_FILE_PATH/$REP_FILE`

 	while IFS='' read -r line; do          (to preserve leading and trailing  spacees used IFS='' read -r )
  		i=0
        	while read line_1; do
           	 field[1]=`cut -d',' -f1 <<<"$line_1"`
            	field[2]="`cut -d',' -f2 <<<"$line_1"`
            	cnt=`echo -n "$line" | grep -o "${field[1]}" | wc -l`
           
            	if [[ "$cnt" -gt 1 ]] ; then
            	sed -e "s/"${field[1]}"/"${field[2]}"/2g"  <<<"$line" >> tmp.txt
            	break
            	fi
        	let i++
            	done < file2.txt
        done< file1.txt

time . XX
real    0m0.308s
user    0m0.192s
sys    0m0.119s

time . YY
real    0m0.014s
user    0m0.012s
sys    0m0.000s

while IFS='' read -r line
         do     while IFS=, read field1 field2
                        do      TMP=${line//$field1}
                                if [ $(( (${#line}- ${#TMP}) / ${#field1} )) -gt 1 ]
                                        then    sed  "s/"$field1"/"$field2"/2g"  <<<"$line" >> tmp.txt
                                        break
                                fi
                        done < file2
        done < file1
cat tmp.txt
TEXAS CALIFORNIA TX
DALLAS CALIFORNIA CALIFORNIA DA DA TEXAS

unset i
while IFS=, read field1[++i] field2[i]; do : ; done < file2
while IFS='' read -r line
         do     for (( i=1; i<=${#field1[@]}; i++ ))
                        do      TMP=${line//${field1[$i]}}
                                if [ $(( (${#line}- ${#TMP}) / ${#field1[$i]} )) -gt 1 ]
                                        then    sed "s/"${field1[$i]}"/"${field2[$i]}"/2g"  <<<"$line" >> tmp.txt
                                        break
                                fi
                        done
        done < file1

time . ZZ

real    0m0.015s
user    0m0.003s
sys    0m0.013s

sed 's#\([^,]*\),\(.*\)#s/\1/\2/2g;t#' <FILE2.txt >FILE2.sed

sed -f FILE2.sed <FILE1.txt >RESULT.txt

sed 's#.*#s,&,2g#' FILE2.txt >FILE2.sed
sed -f FILE2.sed FILE1.txt >RESULT.txt

awk 'NR==FNR {r[$1]=$2; next} ($1 in r) {for (i=2; i<=NF; i++) if ($i==$1) $i=r[$i]} 1' FS=, FILE2.txt FS=" " FILE1.txt