Shell Programming and Scripting

awk 'BEGIN {cnt = split ("# Drug_Target_.*_Gene_Name|# Brand_Name|# Generic_Name|# Drug_Type|# Indication|# Mechanism_Of_Action", SA, "|")}
     {for (i=1; i<=cnt; i++) if (match ($1, SA[i])) Out[i]=$2}
     END {for (i=1; i<=cnt; i++) printf "%-28s", SA[i];  printf "\n";
          for (i=1; i<=cnt; i++) printf "%-28s", Out[i]; printf "\n" }
    ' FS="\n" RS="\n\n" /tmp/Input\ file.txt 
# Drug_Target_.*_Gene_Name  # Brand_Name                # Generic_Name              # Drug_Type                 # Indication                # Mechanism_Of_Action       
F2                          Refludan                    Lepirudin                   Approved                    For the treatment of heparin-induced thrombocytopeniaLepirudin form

bash-3.2$ awk 'BEGIN {cnt = split ("# Drug_Target_.*_Gene_Name|# Brand_Name|# Generic_Name|# Drug_Type|# Indication|# Mechanism_Of_Action", SA, "|")}
>      {for (i=1; i<=cnt; i++) if (match ($1, SA[i])) Out[i]=$2}
>      END {for (i=1; i<=cnt; i++) printf "%-28s", SA[i];  printf "\n";
>           for (i=1; i<=cnt; i++) printf "%-28s", Out[i]; printf "\n" }
>     ' FS="\n" RS="\n\n" drugbank.txt
# Drug_Target_.*_Gene_Name  # Brand_Name                # Generic_Name              # Drug_Type                 # Indication                # Mechanism_Of_Action       
CFTR                        Kalydeco                    Ivacaftor                   Approved                    For the treatment of cystic fibrosis (CF) in patients age 6 years and older who have a G551D mutation in the CFTR gene.Cystic fibrosis is caused by any one of several defects in a protein, cystic fibrosis transmembrane conductance regulator, which regulates fluid flow within cells and affects the components of sweat, digestive fluids, and mucus. The defect, which is caused by a mutation in the individual's DNA, can be in any of several locations along the protein, each of which interferes with a different function of the protein. One mutation, G551D, lets the CFTR protein reach the epithelial cell surface, but doesn't let it transport chloride through the ion channel. Ivacaftor is a potentiator of the CFTR protein. The CFTR protein is a chloride channel present at the surface of epithelial cells in multiple organs. Ivacaftor facilitates increased chloride transport by potentiating the channel-open probability (or gating) of the G551D-CFTR protein.
bash-3.2$

awk 'BEGIN {cnt = split ("# Drug_Target_.*_Gene_Name|# Brand_Name|# Generic_Name|# Drug_Type|# Indication|# Mechanism_Of_Action", SA, "|")}
     foreach (cnt){{for (i=1; i<=cnt; i++) if (match ($1, SA[i])) Out[i]=$2}
     END {for (i=1; i<=cnt; i++) printf "%-28s", SA[i];  printf "\n";
          for (i=1; i<=cnt; i++) printf "%-28s", Out[i]; printf "\n" }}
    ' FS="\n" RS="\n\n"