hi people;
the similar topic is being opened in here and here but i have confused with following condition. so i wanted to open a seperate topic.
from my file.txt:
...
...
...
110105-16:04:04 192.168.1.1 7.1j Port_NODE_MODEL_M_1_8 stopfile=/tmp/10544
=================================================================
MO Attribute Value
=================================================================
Sector=1 height 2500
Sector=3 height 2500
Sector=2 height 2500
=================================================================
Total: 3 results
...
...
110105-16:04:04 192.168.1.1 7.1j Port_NODE_MODEL_M_1_8 stopfile=/tmp/10544
==================================================================
MO Attribute Value
==================================================================
PredefRbsScannerGpeh=1 fileLocation /c/pm_data/
==================================================================
Total: 1 results
...
...
110105-16:04:04 192.168.1.1 7.1j Port_NODE_MODEL_M_1_8 stopfile=/tmp/10544
==================================================================
MO Attribute Value
==================================================================
==================================================================
Total: 0 results
...
...
110105-16:04:04 192.168.1.1 7.1j Port_NODE_MODEL_M_1_8 stopfile=/tmp/10544
==================================================================
MO Attribute Value
==================================================================
SectorAntenna=3,AntennaBranch=A fqBandHighEdge 21550
SectorAntenna=3,AntennaBranch=B fqBandHighEdge 21550
SectorAntenna=1,AntennaBranch=B fqBandHighEdge 21550
SectorAntenna=1,AntennaBranch=A fqBandHighEdge 21550
SectorAntenna=2,AntennaBranch=B fqBandHighEdge 21550
SectorAntenna=2,AntennaBranch=A fqBandHighEdge 21550
==================================================================
...
...
110105-16:04:04 192.168.4.2 7.1j Port_NODE_MODEL_M_1_8 stopfile=/tmp/10544
==================================================================
MO Attribute Value
==================================================================
Sector=1 height 2700
Sector=3 height 2700
Sector=2 height 2700
===================================================================
Total: 3 results
...
this report will be put into excel and it must be seen clearly. so i want to see this report as:
it is enough to group these values and write them seperated with tab. but the problem is, some attributes have 3-sectors where some of them has 1-sector, some of them have 6. so the tabs must be put carefully.
i have really confused
192.168.1.1 Sector=1 height 2500 PredefRbsScannerGpeh=1 fileLocation /c/pm_data/ SectorAntenna=3,AntennaBranch=A fqBandHighEdge 21550
Sector=3 height 2500 SectorAntenna=3,AntennaBranch=B fqBandHighEdge 21550
Sector=2 height 2500 SectorAntenna=1,AntennaBranch=B fqBandHighEdge 21550
SectorAntenna=1,AntennaBranch=A fqBandHighEdge 21550
SectorAntenna=2,AntennaBranch=B fqBandHighEdge 21550
SectorAntenna=2,AntennaBranch=A fqBandHighEdge 21550
... ... ... ... ... ... ... ...
... ... ... ... ... ... ... ...
192.168.4.2 Sector=1 height 2700 PredefRbsScannerGpeh=1 fileLocation /d/pm_data/ SectorAntenna=3,AntennaBranch=A fqBandHighEdge 31550
Sector=3 height 2700 SectorAntenna=3,AntennaBranch=B fqBandHighEdge 31550
Sector=2 height 2700 SectorAntenna=1,AntennaBranch=B fqBandHighEdge 31550
SectorAntenna=1,AntennaBranch=A fqBandHighEdge 31550
SectorAntenna=2,AntennaBranch=B fqBandHighEdge 31550
SectorAntenna=2,AntennaBranch=A fqBandHighEdge 31550
... ... ... ... ... ... ... ...
... ... ... ... ... ... ... ...
hard to tell, hard to understand, really hard to script it..!!