Shell Programming and Scripting

Hi guys,

I have a text file like in following format,

IMSI:1
MSISDN:44569098
Data1=prov
Data2=yes
Data3=not
Data4=yes
Data5=yes
Data6=yes

IMSI:2
MSISDN:44569099
Data1=yes
Data2=not
Data3=prov
Data4=prov

IMSI:3
MSISDN:44709098
Data1=prov
Data2=yes
Data3=not
Data4=prov
Data5=not
Data6=yes

So I need to convert it as follows,

IMSI:1,MSISDN:44569098,Data1=prov,Data2=yes,Data3=not,Data4=yes,Data5=yes,Data6=yes
IMSI:2,MSISDN:44569099,Data1=yes,Data2=not,Data3=prov,Data4=prov
IMSI:3,MSISDN:44709098,Data1=prov,Data2=yes,Data3=not,Data4=prov,Data5=not,Data6=yes

Can somebody give me a idea, how to do it.

Thanks,
Regards,
Mahesh

Code:

nawk -v RS='' -v OFS=',' '$1=$1' myFile.txt

Hi Friend,

This is working fine.
One problem ?
My file size it about 48MB. Is there any limitation of file size in awk utility.

I get a error message as follows,


awk: Input line <SUBBEGIN
MODE=ADDS cannot be longer than 3,000 bytes.

My real file input as follows,

<SUBBEGIN
MODE=ADDSUB;
IMSI=616040200000599;
MSISDN=22993140998;
CAT=COMMON;
CURRENTNAM=NONGPRS;
SMDP=MSC;
KI_USEDFLAG=YES;
TBS=TS11&TS12&TS21&TS22&TS61&TS62&BS21&BS22&BS23&BS24&BS25&BS26&BS31&BS32&BS33&BS34&BS41&BS42&BS43&B S44&BS45&BS46&BS51&BS52&BS53&BS61&BS62&BS81&BS82;
CONTROL=SUB;
PW=0000;
WPA=0;
VLR=22993239000;
MSC=22993239000;
OCSI=0;
TCSI=1;
SSCSI=5;
DEFCALL=TS11;
<SUBEND
<SUBBEGIN
MODE=ADDSUB;
IMSI=616040200000598;
MSISDN=22993140990;
CAT=COMMON;
CURRENTNAM=NONGPRS;
SMDP=MSC;
KI_USEDFLAG=YES;
TBS=TS11&TS12&TS21&TS22&TS61&TS62&BS21&BS22&BS23&BS24&BS25&BS26&BS31&BS32&BS33&BS34&BS41&BS42&BS43&B S44&BS45&BS46&BS51&BS52&BS53&BS61&BS62&BS81&BS82;
CONTROL=SUB;
PW=0000;
WPA=0;
VLR=22993239000;
MSC=22993239000;
OCSI=0;
TCSI=1;
SSCSI=5;
DEFCALL=TS11;
<SUBEND
<SUBBEGIN

Can u give me a suggestion. ?

Thanks,
Mahesh

there are some awk limitation and they vary from one OS/awk verion to the other.
If you're on Solaris, try using either '/usr/bin/nawk' OR '/usr/xpg4/bin/awk'.
If you have 'gawk' installed on your system, try using that instead.