Manuplating text

arn2025 · 03-20-2012, 03:06 AM

I have a very long text file that I want to change into columns so that it is arranged as

SID PCRFINDEX SUBSCRIBERSN SUBSCRIBERIDENTIFIER
730B020246D48407 0 730B060246D48407 256310903857
730B0A02B8D48407 0 730B0E02B8D48407 256310904578

"
<SUBBEGIN
SID=730B020246D48407;
PCRFINDEX=0;
SUBSCRIBERSN=730B060246D48407;
SUBSCRIBERIDENTIFIER=256310903857;
MSISDN=310903857;
STATUS=1;
PAIDTYPE=254;
STATION=1;
CONTACTMETHOD=2;
BILLINGCYCLEDAY=26;
DOMAINNAME=default1;
DOMAINID=0000000000000063;
SPNAME=default1;
SPID=0000000000000063;
ONLINESTATUS=2;
<SUBEND
<SUBBEGIN
SID=730B0A02B8D48407;
PCRFINDEX=0;
SUBSCRIBERSN=730B0E02B8D48407;
SUBSCRIBERIDENTIFIER=256310904578;
MSISDN=310904578;
STATUS=1;
PAIDTYPE=254;
STATION=1;
CONTACTMETHOD=2;
BILLINGCYCLEDAY=26;
DOMAINNAME=default1;
DOMAINID=0000000000000063;
SPNAME=default1;
SPID=0000000000000063;
ONLINESTATUS=2;
<SUBEND
<SUBBEGIN
SID=730B120232D58407;
PCRFINDEX=0;
SUBSCRIBERSN=730B160232D58407;
SUBSCRIBERIDENTIFIER=256310901978;
MSISDN=310901978;
STATUS=1;
PAIDTYPE=254;
STATION=1;
CONTACTMETHOD=2;
BILLINGCYCLEDAY=26;
DOMAINNAME=default1;
DOMAINID=0000000000000063;
SPNAME=default1;
SPID=0000000000000063;
ONLINESTATUS=2;
<SUBEND

druuna · 03-20-2012, 03:23 AM

Hi,

Is this what you are looking for:

Code:

awk 'BEGIN { RS="<SUBBEGIN" ; FS = "\n" } { gsub(/([A-Z]+=|;)/,"",$0 ) ; print $2, $3, $4, $5 }' infile

Sample run with the data given in post #1:

Code:

$ awk 'BEGIN { RS="<SUBBEGIN" ; FS = "\n" } { gsub(/([A-Z]+=|;)/,"",$0 ) ; print $2, $3, $4, $5 }' infile
730B020246D48407 0 730B060246D48407 256310903857
730B0A02B8D48407 0 730B0E02B8D48407 256310904578
730B120232D58407 0 730B160232D58407 256310901978

Hope this helps.

arn2025 · 03-20-2012, 06:08 AM

Thanks, this really worked