Dear All,

         I am shailesh. Just need small help to write a shell script.

         There are two tables T1 and T2 both tables one row is common.

         i have to filter out subIndx (common keyword),imsi,msisdn from both 
tables



       Here table T1



(1)------------------------------------------------

subIndx         : 1

tmsiReuseCounter: 0x0

subStatus       : 0

authCntr        : 0x0

subFlags        : 15

timeStamp       : 1328101313

(2)------------------------------------------------

subIndx         : 2

tmsiReuseCounter: 0x0

subStatus       : 0

authCntr        : 0x0

subFlags        : 14

timeStamp       : 1328092111

(3)------------------------------------------------

subIndx         : 3

tmsiReuseCounter: 0x0

subStatus       : 0

authCntr        : 0x0

subFlags        : 14

timeStamp       : 1328092352

(4)------------------------------------------------

subIndx         : 16

tmsiReuseCounter: 0x0

subStatus       : 0

authCntr        : 0x0

subFlags        : 14

timeStamp       : 1328100251

------------------------------------------------

Total Records = 4 





Here table T2





subIndx  : 1

imsi     : 005050000001057

msisdn   : 19919680301057

pTmsi[0] : 0x0

pTmsi[1] : 0x0

pTmsi[2] : 0x0

pTmsi[3] : 0x0

nTmsi[0] : 0x0

nTmsi[1] : 0x0

nTmsi[2] : 0x0

nTmsi[3] : 0x0

imei[0]  : 0x0

imei[1]  : 0x0

imei[2]  : 0x0

imei[3]  : 0x0

imei[4]  : 0x0

imei[5]  : 0x0

imei[6]  : 0x0

imei[7]  : 0x0

(2)------------------------------------------------

subIndx  : 2

imsi     : 005050000011350

msisdn   : 19919685311350

pTmsi[0] : 0x0

pTmsi[1] : 0x0

pTmsi[2] : 0x0

pTmsi[3] : 0x0

nTmsi[0] : 0x0

nTmsi[1] : 0x0

nTmsi[2] : 0x0

nTmsi[3] : 0x0

imei[0]  : 0x0

imei[1]  : 0x0

imei[2]  : 0x0

imei[3]  : 0x0

imei[4]  : 0x0

imei[5]  : 0x0

imei[6]  : 0x0

imei[7]  : 0x0

(3)------------------------------------------------

subIndx  : 3

imsi     : 005050000011347

msisdn   : 19919685311347

pTmsi[0] : 0x0

pTmsi[1] : 0x0

pTmsi[2] : 0x0

pTmsi[3] : 0x0

nTmsi[0] : 0x0

nTmsi[1] : 0x0

nTmsi[2] : 0x0

nTmsi[3] : 0x0

imei[0]  : 0x0

imei[1]  : 0x0

imei[2]  : 0x0

imei[3]  : 0x0

imei[4]  : 0x0

imei[5]  : 0x0

imei[6]  : 0x0

imei[7]  : 0x0

(4)------------------------------------------------

subIndx  : 16

imsi     : 005050000011351

msisdn   : 19919685311351

pTmsi[0] : 0x0

pTmsi[1] : 0x0

pTmsi[2] : 0x0

pTmsi[3] : 0x0

nTmsi[0] : 0x0

nTmsi[1] : 0x0

nTmsi[2] : 0x0

nTmsi[3] : 0x0

imei[0]  : 0x0

imei[1]  : 0x0

imei[2]  : 0x0

imei[3]  : 0x0

imei[4]  : 0x0

imei[5]  : 0x0

imei[6]  : 0x0

imei[7]  : 0x0

------------------------------------------------

Total Records = 4       





Please help me.



Thanks

shailesh kumar

9873848649
_______________________________________________
Ilugd mailing list
[email protected]
http://frodo.hserus.net/mailman/listinfo/ilugd

Reply via email to