Shell Programming and Scripting

AABC
TTYP
JKBH
CVBN
NHJK
KJHM

AABC,XCYU,JUHD      Alllele1        GACXT  It is approved study
TTYP,JKBH               Allele2         PPRD      It is clinical trial study   
JKBH                         Allele2         PPRD      It is clinical trial study 
CVBN                      Allele23        PKHGN     It is clinical trial study 
NHJK,CVBN                Allele2         PPRD      It is clinical trial study 
KJHM,CVBN,GHCY,BVCHJ             Allele5         PPRD      It is approved/clinical trial study

AABC    Alllele1        GACXT  It is approved study
TTYP              Allele2         PPRD      It is clinical trial study
JKBH               Allele2         PPRD      It is clinical trial study   
JKBH                Allele2         PPRD      It is clinical trial study 
CVBN               Allele23        PKHGN     It is clinical trial study 
NHJK,              Allele2         PPRD      It is clinical trial study 
CVBN                Allele2         PPRD      It is clinical trial study 
KJHM                Allele5         PPRD      It is approved/clinical trial study 
CVBN                Allele5         PPRD      It is approved/clinical trial study

awk 'NR==FNR{X[$1]=$0;next}{n=split($1,P," ");sub($1,"",$0);for(i=1;i<=n;i++){if(X[P[i]]){print P[i],$0}}}' file1 FS="\t" file2

awk 'FNR == NR {f[$1]; next}
{       for(n = split($1, f1, ","); n > 0; n--)
                if(f1[n] in f) {
                        $1 = f1[n]
                        print
                }
}' first.txt FS="\t" OFS="\t" second.txt

CTSD    Insulin recombinant     Novolin R (Novo Nordisk)        Approved        For treatment of Type I and II diabetes mellitus.
CTSD    Insulin, porcine        Iletin II       Approved        For the treatment of type I and II diabetes mellitus.
LCT     Vitamin C       Adenex  Approved        Used to treat vitamin C deficiency, scurvy, delayed wound and bone healing, urine acidification, and in general as an antioxidant. It has also been suggested to be an effective antiviral agent.
B4GALT1 N-Acetyl-D-glucosamine  Aflexa  Approved        For the treatment and prevention of osteoarthritis, by itself or in combination with chondroitin sulfate.
PPARD   Icosapent       Not Available   Approved        EPA can be used for lowering elevated triglycerides in those who are hyperglyceridemic. In addition, EPA may play a therapeutic role in patients with cystic fibrosis by reducing disease severity and may play a similar role in type 2 diabetics in slowing the progression of diabetic nephropathy.
NR3C1   Flunisolide     Aerobid Approved        For the maintenance treatment of asthma as a prophylactic therapy.
CHRM1   Cevimeline      Evoxac  Approved        For the treatment of symptoms of dry mouth in patients with Sjögren's Syndrome.

awk '{  gsub(/\r/, "")
        gsub(/ *\t/, "\t")}
FNR == NR {f[$1]
        next}
{       for(n = split($1, f1, ","); n > 0; n--)
                if(f1[n] in f) {
                        $1 = f1[n]
                        print
                }
}' pHARMGKBT2D.txt FS="\t" OFS="\t" second.txt