Shell Programming and Scripting

awk -F"|" FNR==NR'{A[$1 FS $3]=A[$1 FS $3]?A[$1 FS $3] s1 "," s1 $NF:$NF;next} {D=$1 FS $3} (D in A){X[$1]=X[$1]?X[$1] OFS A[D]:A[D]} END{for(i in X){split(X[i], Q," ");print "Key = " i ORS "GiftQuantity=" Q[1] ORS "MinimumPurchase=" Q[2] ORS "GiftCatalogEntryIdentifier= " s2 s1 Q[3] s1 s3 ORS}}' s1="'" s2="(" s3=")"  Input_file  Input_file

Key = 11055005
GiftQuantity=1
MinimumPurchase=400
GiftCatalogEntryIdentifier= ('207328014')
 
Key = 11429510
GiftQuantity=1
MinimumPurchase=100
GiftCatalogEntryIdentifier= ('205955413','205955533','205955364')

awk -F"|" FNR==NR'{
                        A[$1 FS $3]=A[$1 FS $3]?A[$1 FS $3] s1 "," s1 $NF:$NF;
                        next
                  }
                  {
                        D=$1 FS $3
                  }
                        (D in A){
                                        X[$1]=X[$1]?X[$1] OFS A[D]:A[D]
                                }
          END     {
                        for(i in X){
                                        split(X[i], Q," ");
                                        print "Key = " i ORS "GiftQuantity=" Q[1] ORS "MinimumPurchase=" Q[2] ORS "GiftCatalogEntryIdentifier= " s2 s1 Q[3] s1 s3 ORS
                                   }
                  }
                 ' s1="'" s2="(" s3=")" Input_file  Input_file

awk -F"|" '
{
    k[$1]=k[$1] OFS $4 # build data string containing giftquantity, minimumpurchase and giftids for each key
}
END{                   # after the whole file has been quantified
    for(i in k){       # for each key string do the following
        n=split(k[i], r, OFS)     # divide the data into tokens
        for(e=3;e<=n;e++){        # iterate through giftids found
            ids=(ids) ? ids "," q r[e] q : q r[e] q  # build the formated giftids section
        }
        # output the whole nine yards
        printf "Key=%s\nGiftQuantity=%s\nMinimumPurchase=%s\nGiftCatalogIdentifier=(%s)\n\n", i, r[1], r[2], ids
    }
}' q="'" mohanalakshmi.file

Key=11055005
GiftQuantity=1
MinimumPurchase=400
GiftCatalogIdentifier=('207328014')

Key=11429510
GiftQuantity=1
MinimumPurchase=100
GiftCatalogIdentifier=('207328014','205955413','205955533','205955364')