UNIX for Beginners Questions & Answers

time sh ou.awk 
real    0m4.469s
user    0m4.400s
sys     0m0.040s

time awk -f gil.awk DS2_export100217.ldif
real    0m1.713s
user    0m1.076s
sys     0m0.072s

time awk -f mline.awk DS2_export100217.ldif
real    0m0.833s
user    0m0.752s
sys     0m0.072s

time ./ou.awk >output                    
real    0m0.678s
user    0m0.660s
sys     0m0.016s

awk -F: '
BEGIN           {HD="MSISDN,IMSI,NAM,TS11,TS21,TS22,TS62,BAIC,BAOC,APNID1,APNID2"       # define the fields to extract, and prepare a header for eventual print
                 for (i=HDCnt=split(HD, HDArr, ","); i>0; i--)  X[HDArr[i]]             # create am "associative" array  for later $1 matching 
                 NXTREC = "dn"                                                          # this is where the next record starts
                }


$1 == NXTREC    {if (PR) for (i=1; i<=HDCnt; i++) printf "%s%s", RES[HDArr[i]], i==HDCnt?ORS:OFS
                                                                                        # print old record collected up to now; don't on the first record (Pr still undefined)
                 split ("", RES)                                                        # remoce RES array
                 PR = 1                                                                 # define the PR logical var so all next records are printed
                }

$1 in X         {RES [$1] = $0                                                          # collect data line if $1 is among the requested fields
                }

END             {for (i=1; i<=HDCnt; i++) printf "%s%s", RES[HDArr[i]], i==HDCnt?ORS:OFS
                }                                                                       # see above for the last record

' FS=":" OFS="," DS2_export100217.ldif

dn: EpsStaInfId=EpsStaInf,serv=EPS,mscId=aaaaaa001aaaaaaaa629100100138702,ou=multiSCs,dc=mtncg
structuralObjectClass: EpsStaticInf
objectClass: EpsStaticInf
entryDS: 1
nodeId: 1
createTimestamp: 20170119123400Z
modifyTimestamp: 20170119123400Z
EpsStaInfId: EpsStaInf
EpsProfileId: 29
EpsOdb: 0
EpsRoamAllow: TRUE
CDC: 1
EpsIndSubChargChars: 123

dn: EpsStaInfId=EpsStaInf,serv=EPS,mscId=aaaaaa001aaaaaaaa629100100165619,ou=multiSCs,dc=mtncg
structuralObjectClass: EpsStaticInf
objectClass: EpsStaticInf
entryDS: 1
nodeId: 1
createTimestamp: 20170211115449Z
modifyTimestamp: 20170211115449Z
EpsStaInfId: EpsStaInf
EpsProfileId: 29
EpsOdb: 0
EpsRoamAllow: TRUE
CDC: 1
EpsIndSubChargChars: 123