Shell Programming and Scripting

benzene   blood disorders
 nitrozen    air disease

AXY  benzene, nitrogen,  oxygen, not available, sulfur
VTY  nitrogen, notavailable, sulfur

AXY  benzene (blood disorders), nitrogen (air disease),  oxygen, not available, sulfur.
VTY  nitrogen (air disease), notavailable, sulfur

awk 'NR==FNR{lookup[$1]=$2;for(i=3;i<=NF;i++)lookup[$1]=lookup[$1]" "$i;next}
{ sub(/ /,",");
 printf $1" ";
 for(i=2;i<=NF;i++) {
    key=$i;
    gsub(/^  */,"",key);
    if(i>2) printf ",";
    printf "%s", $i;
    if (key in lookup) printf " (%s)", lookup[key]
 }
 printf "\n"}' fileA FS="," fileB

bash-3.2$ awk 'NR==FNR{lookup[$1]=$2;for(i=3;i<=NF;i++)lookup[$1]=lookup[$1]" "$i;next}
{ sub(/ /,",");
 printf $1" ";
 for(i=2;i<=NF;i++) {
    key=$i;
    gsub(/^  */,"",key);
    if(i>2) printf ",";
    printf "%s", $i;
    if (key in lookup) printf " (%s)", lookup[key]
 }
 printf "\n"}' drugbankdrugs FS="," drugbanktest >drugabnktest1
bash-3.2$

 awk 'NR==FNR{x=$1;print x;$1=y;a[x]=$0;next}{x=$1;printf x" ";$1=y;n=split($0,b,",");for(i=1;i<=n;i++){sub(" ","",b[i]);if(a[b[i]]){printf "%s (%s),",b[i],a[b[i]]}else{printf "%s ,",b[i]}};printf "\n"}' file1 file2

awk {printf "s/" $1 "/& (" ; for (i=2;i<=NF-1;i++) { printf $i " "};printf $NF")/g\n"} drugs.txt > file_sed

s/benzene/& (blood disorders)/g
s/nitrogen/& (air disease)/g

sed -f file_sed drugbankdrugs.txt > file_output

bash-3.2$ awk {printf "s/" $1 "/& (" ; for (i=2;i<=NF-1;i++) { printf $i " "};printf $NF")/g\n"} drugs.txt > file_sed
bash: syntax error near unexpected token `('