Select lines from a file based on a criteria

Shell Programming and Scripting
1

Hi

I need to select lines from a txt file, I have got a line starting with ZMIO:MSISDN= and after a few line I have another line starting with 'MOBILE STATION ISDN NUMBER' and another one starting with 'VLR-ADDRESS' I need to copy these three lines as three different columns in a separate file.

thanks in advance

my file looks like this

HOME SUBSCRIBER IDENTIFICATION HANDLING COMMAND <MI_>
<  ZMIO:MSISDN=12345678:;

LOADING PROGRAM VERSION 13.18-0

HLRi      DM1HLR01                  2013-01-31  18:27:51

                SUBSCRIBER INFORMATION:

        INTERNATIONAL MOBILE SUBSCRIBER IDENTITY ... 4324567891234 
        MOBILE STATION ISDN NUMBER ................. 12345678    
        ATTACHED IMSI ..............................                 
        MOBILE STATION CATEGORY .................... OR  
        ROUTING CATEGORY ........................... 22 
        ADDITIONAL ROUTING CATEGORY ................ N    
        SERVICE AREA OF MSISDN ..................... ALL
        ACTIVATION STATUS .......................... A    
        VLR-ADDRESS ................................                 
        SIGNALLING POINT CODE ...................... 00000000
        MSC-ADDRESS ................................                 
        PRIMARY BASIC SERVICE CODE ................. T11
        PRIMARY BASIC SERVICE CODE INDEX ........... 000
        ROAMING PROFILE INDEX ...................... 26
        FRAUD PROFILE .............................. N  
        CALLING LINE IDENTIFICATION ENHANCEMENT .... N
        COMMON MSISDN NUMBER ....................... N               
        OVERRIDE COMMON CLI PARAMETERS ............. N
        CMSISDN IS HUNTING GROUP NUMBER ............ N
        DENY DIRECT CALLS .......................... N
        DENY USSD WITH MEMBER NUMBER ............... N
        DENY DIRECT SMS ............................ N

        ZONE CODES:
                 

        MSC AREA RESTRICTED ........................ N

        HLRU IDENTITY .............................. 6

        HOME COUNTRY CODE .......................... N  
        NETWORK DESTINATION CODE ................... N    


COMMAND EXECUTED


<  ZMIO:MSISDN=98765432134:;

LOADING PROGRAM VERSION 13.18-0

HLRi      DM1HLR01                  2013-01-31  18:27:54

                SUBSCRIBER INFORMATION:

        INTERNATIONAL MOBILE SUBSCRIBER IDENTITY ... 32134567895467 
        MOBILE STATION ISDN NUMBER ................. 98765432134 
        ATTACHED IMSI ..............................                 
        MOBILE STATION CATEGORY .................... OR  
        ROUTING CATEGORY ........................... 52 
        ADDITIONAL ROUTING CATEGORY ................ N    
        SERVICE AREA OF MSISDN ..................... ALL
        ACTIVATION STATUS .......................... A    
        VLR-ADDRESS ................................ 96431324567 
        SIGNALLING POINT CODE ...................... 00000000
        MSC-ADDRESS ................................ 543213456789    
        PRIMARY BASIC SERVICE CODE ................. T22
        PRIMARY BASIC SERVICE CODE INDEX ........... 000
        ROAMING PROFILE INDEX ...................... 6 
        FRAUD PROFILE .............................. N  
        CALLING LINE IDENTIFICATION ENHANCEMENT .... N
        COMMON MSISDN NUMBER ....................... N               
        OVERRIDE COMMON CLI PARAMETERS ............. N
        CMSISDN IS HUNTING GROUP NUMBER ............ N
        DENY DIRECT CALLS .......................... N
        DENY USSD WITH MEMBER NUMBER ............... N
        DENY DIRECT SMS ............................ N

        ZONE CODES:
                 

        MSC AREA RESTRICTED ........................ N

        HLRU IDENTITY .............................. 3

        HOME COUNTRY CODE .......................... N  
        NETWORK DESTINATION CODE ................... N    


COMMAND EXECUTED
2

PLEASE use code tags as demanded in forum rules!
If the order of the keys is always fixed and as you stat above, try

awk '/ZMIO:MSISDN|MOBILE STATION ISDN NUMBER/ {printf "%s%s", $0, OFS}    # either pattern matched, print to same line
     /VLR-ADDRESS/                                                        # pattern matched - take default action (print $0)
    ' file
< ZMIO:MSISDN=12345678:; MOBILE STATION ISDN NUMBER .... 12345678 VLR-ADDRESS .....
< ZMIO:MSISDN=98765432134:; MOBILE STATION ISDN NUMBER .... 98765432134 VLR-ADDRESS .... 96431324567
3

Hi

thanks for the reply,

Is there any way that I can insert a critieria that if the numerical in the line

ZMIO:MSISDN=12345678

matches

the numerical in this line

MOBILE STATION ISDN NUMBER ................. 12345678

only then the files will be selected otherwise no

4

PLEASE use code tags as demanded in forum rules!

$ awk  '/ZMIO:MSISDN/                  {tmp1 = $0; gsub(/[^0-9]/,"", $NF); key1 = $NF}
        /MOBILE STATION ISDN NUMBER/   {tmp2 = $0; gsub(/[^0-9]/,"", $NF); key2 = $NF}
        /VLR-ADDRESS/ && (key1==key2)  {printf "%s%s%s%s%s\n", tmp1, OFS, tmp2, OFS, $0}
       ' file