anupamduttabesu
New Member
- Joined
- Mar 24, 2013
- Messages
- 5
Hi
I have a data in text in the below fomat...
<dbtsp:tab=axepars;
DATABASE TABLE
BLOCK TAB TABLE WRAPPED
PARA AXEPARS YES
NAME SETNAME PARID VALUE UNIT CLASS DISTRIB
EMERGENCYMODE AXELMCPF 8191 0 FEATURE IMMED
STATUS FCVSET FCVALUE DCINFO FCODE
UPDATED FALSE 0 UNDEF 0
NAME SETNAME PARID VALUE UNIT CLASS DISTRIB
SCCPCONGCTRL CCSF 8190 0 FEATURE IMMED
STATUS FCVSET FCVALUE DCINFO FCODE
UPDATED FALSE 0 UNDEF 0
END
I need to convert it into the below excel format.....
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
Here from the text we have to take the data beneath the header.In the excel i have a common header and from the text the data will be read and pest in the excel under the header.
Please help me how to do it.
I have a data in text in the below fomat...
<dbtsp:tab=axepars;
DATABASE TABLE
BLOCK TAB TABLE WRAPPED
PARA AXEPARS YES
NAME SETNAME PARID VALUE UNIT CLASS DISTRIB
EMERGENCYMODE AXELMCPF 8191 0 FEATURE IMMED
STATUS FCVSET FCVALUE DCINFO FCODE
UPDATED FALSE 0 UNDEF 0
NAME SETNAME PARID VALUE UNIT CLASS DISTRIB
SCCPCONGCTRL CCSF 8190 0 FEATURE IMMED
STATUS FCVSET FCVALUE DCINFO FCODE
UPDATED FALSE 0 UNDEF 0
END
I need to convert it into the below excel format.....
NAME</SPAN> | SETNAME</SPAN> | PARID</SPAN> | VALUE</SPAN> | UNIT</SPAN> | CLASS</SPAN> | DISTRIB</SPAN> | STATUS</SPAN> | FCVSET</SPAN> | FCVALUE</SPAN> | DCINFO</SPAN> | FCODE</SPAN> |
EMERGENCYMODE</SPAN> | AXELMCPF</SPAN> | 8191</SPAN> | 0</SPAN> | FEATURE</SPAN> | IMMED</SPAN> | UPDATED</SPAN> | FALSE</SPAN> | 0</SPAN> | UNDEF</SPAN> | 0</SPAN> | |
SCCPCONGCTRL</SPAN> | CCSF</SPAN> | 8190</SPAN> | 0</SPAN> | FEATURE</SPAN> | IMMED</SPAN> | UPDATED</SPAN> | FALSE</SPAN> | 0</SPAN> | UNDEF</SPAN> | 0</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
Here from the text we have to take the data beneath the header.In the excel i have a common header and from the text the data will be read and pest in the excel under the header.
Please help me how to do it.