[ilugd] Shell Script Query

2012-02-28 Thread shailesh kumar
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 : 00505001057

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 : 00505011350

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 : 00505011347

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 : 00505011351

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
Ilugd@lists.linux-delhi.org
http://frodo.hserus.net/mailman/listinfo/ilugd


Re: [ilugd] Shell Script Query

2012-02-28 Thread Raj Mathur (राज माथुर)
On Wednesday 29 Feb 2012, shailesh kumar wrote:
 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

Without knowing more about the application, and going by the sample data 
you have provided, I'd suggest you make single-line entries for each set 
of data in each table, and then use sort/join to filter your data.

Regards,

-- Raj
-- 
Raj Mathur  || r...@kandalaya.org   || GPG:
http://otheronepercent.blogspot.com || http://kandalaya.org || CC68
It is the mind that moves   || http://schizoid.in   || D17F
___
Ilugd mailing list
Ilugd@lists.linux-delhi.org
http://frodo.hserus.net/mailman/listinfo/ilugd