Dear Team,
Do needful as iam having txt fine contains data in below mention format
================================================================================
TRAIL EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_01
================================================================================
***** MAIN ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p02 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b02p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b01p01 01/1/4.3
HR60_DHR-HIG_01/r01s1b31p002 01/1/4.3
HR60_DHR-HIG_01/r01s1b37p001 37/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b33p001 14/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b34p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b28p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3
VNE_DEL-XDM_01.SL-I01/PT01 01/2/2.3
***** SPARE ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p02 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p01 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p01 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p05 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p01 02/1/1.3
HR60_RWI-GKL_01/r01s1b35p001 02/1/1.3
HR60_RWI-GKL_01/r01s1b26p001 13/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b28p001 37/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b36p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b33p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b32p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b38p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3
================================================================================
TRAIL VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
================================================================================
***** MAIN ROUTE *******
HR60_DHR-HIG_01/r01s1b37p001 37
DHR-HIG_01 SL-37 P-01 TOWARDS DELHI 37
NEW VNE-- 37
VNE_DEL-VSB_03.SLXX/PTYY 37
VNE_DEL-VSB_03.SLxx/PT01 35
VNE_DEL-XDM_01.SL-678/PT04 35
VNE_DEL-XDM_01.SL I/12-02 14
HR60_DEL-VSB_06/r01s1b33p001 14
================================================================================
TRAIL GOKUL BAZAR-DADRI-BHIWANI-HANSI
================================================================================
***** MAIN ROUTE *******
HR60_RWI-GKL_01/r01s1b26p001 13
HR60_RWI-GSM_01/r01s1b33p001 13
HR60_RWI-GSM_01/r01s1b37p001 62
HR60_KNA-HIG_01/r01s1b25p001 62
HR60_KNA-HIG_01/r01s1b34p001 62
HR60_DDR-HIG_02/r01s1b25p001 62
HR60_DDR-HIG_02/r01s1b37p001 62
HR60_BWN-HLS_01/r01s1b28p001 62
HR60_BWN-HLS_01/r01s1b25p001 61
HR60_BWN-GSM_01/r01s1b28p001 61
HR60_BWN-GSM_01/r01s1b34p001 62
HR60_HNS-GSM_01/r01s1b37p001 62
HR60_HNS-GSM_01/r01s1b25p001 37
HR60_HNS-GSM_02/r01s1b25p001 37
HR60_HNS-GSM_02/r01s1b28p001 37
HR60_HNS-BRG_02/r01s1b28p001 37
================================================================================
TRAIL EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_02
================================================================================
***** MAIN ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p01 01/2/1.2
HR42_DRU-HIG_G2/r01s1b01p02 01/2/1.2
HR42_DRU-HIG_G2/r01s1b01p01 01/2/1.2
HR42_DRU-HIG_G1/r01s1b02p01 01/2/1.2
HR42_DRU-HIG_G1/r01s1b01p01 01/1/6.1
HR60_DHR-HIG_01/r01s1b31p002 01/1/6.1
HR60_DHR-HIG_01/r01s1b37p001 37/2/5.1 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b33p001 14/2/5.1 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b34p001 47/2/3.2
HR60_DEL-VSB_05/r01s1b28p001 47/2/3.2
HR60_DEL-VSB_05/r01s1b32p001 01/2/3.3
VNE_DEL-XDM_01.SL-I01/PT01 01/2/3.3
***** SPARE ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p02 01/2/1.2
HR42_JNW-HIG_G1/r01s1b01p01 01/2/1.2
HR42_JNW-HIG_G1/r01s1b01p02 01/2/1.2
HR42_RWI-HSK_G1/r01s1b01p02 01/2/1.2
HR42_RWI-HSK_G1/r01s1b01p01 01/2/2.2
HR62_RWI-SDU_01/r01s1b10p05 01/2/2.2
HR62_RWI-SDU_01/r01s1b10p01 02/3/1.2
HR60_RWI-GKL_01/r01s1b35p001 02/3/1.2
HR60_RWI-GKL_01/r01s1b26p001 02/2/5.3
HR60_RWI-GSM_01/r01s1b33p001 02/2/5.3
HR60_RWI-GSM_01/r01s1b37p001 05/2/7.3 REWARI GSM M-DADRI MUX VC4S1
HR60_DDR-HIG_02/r01s1b25p001 05/2/7.3 REWARI GSM M-DADRI MUX VC4S1
HR60_DDR-HIG_02/r01s1b37p001 03/1/6.1
HR60_BWN-HLS_01/r01s1b28p001 03/1/6.1
HR60_BWN-HLS_01/r01s1b25p001 03/1/2.2
HR60_BWN-GSM_01/r01s1b28p001 03/1/2.2
HR60_BWN-GSM_01/r01s1b34p001 01/3/5.2
HR60_HNS-GSM_01/r01s1b37p001 01/3/5.2
HR60_HNS-GSM_01/r01s1b34p001 05/3/6.2
HR60_HNS-BRG_01/r01s1b25p001 05/3/6.2
HR60_HNS-BRG_01/r01s1b24p001 13/3/1.1
HR60_HNS-BRG_02/r01s1b31p001 13/3/1.1
HR60_HNS-BRG_02/r01s1b36p001 01/1/4.2
HR60_DEL-VSB_03/r01s1b33p001 01/1/4.2
HR60_DEL-VSB_03/r01s1b32p001 11/1/2.3
HR60_DEL-VSB_05/r01s1b38p001 11/1/2.3
HR60_DEL-VSB_05/r01s1b32p001 01/2/3.3
================================================================================
TRAIL VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
================================================================================
***** MAIN ROUTE *******
HR60_DHR-HIG_01/r01s1b37p001 37
DHR-HIG_01 SL-37 P-01 TOWARDS DELHI 37
NEW VNE-- 37
VNE_DEL-VSB_03.SLXX/PTYY 37
VNE_DEL-VSB_03.SLxx/PT01 35
VNE_DEL-XDM_01.SL-678/PT04 35
VNE_DEL-XDM_01.SL I/12-02 14
HR60_DEL-VSB_06/r01s1b33p001 14
================================================================================
TRAIL REWARI GSM M-DADRI MUX VC4S1
================================================================================
where I need Same data to be converted to excel file as
Below
[TABLE="width: 838"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]SR.No[/TD]
[TD]TRAIL[/TD]
[TD]
***** MAIN ROUTE *******[/TD]
[TD]***** SPARE ROUTE *******[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_01[/TD]
[TD]HR42_TTR-HIG_G1/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p02 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b02p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b01p01 01/1/4.3
HR60_DHR-HIG_01/r01s1b31p002 01/1/4.3
HR60_DHR-HIG_01/r01s1b37p001 37/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b33p001 14/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b34p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b28p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3
VNE_DEL-XDM_01.SL-I01/PT01 01/2/2.3 [/TD]
[TD]HR42_TTR-HIG_G1/r01s1b01p02 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p01 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p01 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p05 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p01 02/1/1.3
HR60_RWI-GKL_01/r01s1b35p001 02/1/1.3
HR60_RWI-GKL_01/r01s1b26p001 13/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b28p001 37/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b36p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b33p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b32p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b38p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Do needful as iam having txt fine contains data in below mention format
================================================================================
TRAIL EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_01
================================================================================
***** MAIN ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p02 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b02p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b01p01 01/1/4.3
HR60_DHR-HIG_01/r01s1b31p002 01/1/4.3
HR60_DHR-HIG_01/r01s1b37p001 37/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b33p001 14/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b34p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b28p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3
VNE_DEL-XDM_01.SL-I01/PT01 01/2/2.3
***** SPARE ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p02 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p01 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p01 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p05 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p01 02/1/1.3
HR60_RWI-GKL_01/r01s1b35p001 02/1/1.3
HR60_RWI-GKL_01/r01s1b26p001 13/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b28p001 37/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b36p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b33p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b32p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b38p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3
================================================================================
TRAIL VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
================================================================================
***** MAIN ROUTE *******
HR60_DHR-HIG_01/r01s1b37p001 37
DHR-HIG_01 SL-37 P-01 TOWARDS DELHI 37
NEW VNE-- 37
VNE_DEL-VSB_03.SLXX/PTYY 37
VNE_DEL-VSB_03.SLxx/PT01 35
VNE_DEL-XDM_01.SL-678/PT04 35
VNE_DEL-XDM_01.SL I/12-02 14
HR60_DEL-VSB_06/r01s1b33p001 14
================================================================================
TRAIL GOKUL BAZAR-DADRI-BHIWANI-HANSI
================================================================================
***** MAIN ROUTE *******
HR60_RWI-GKL_01/r01s1b26p001 13
HR60_RWI-GSM_01/r01s1b33p001 13
HR60_RWI-GSM_01/r01s1b37p001 62
HR60_KNA-HIG_01/r01s1b25p001 62
HR60_KNA-HIG_01/r01s1b34p001 62
HR60_DDR-HIG_02/r01s1b25p001 62
HR60_DDR-HIG_02/r01s1b37p001 62
HR60_BWN-HLS_01/r01s1b28p001 62
HR60_BWN-HLS_01/r01s1b25p001 61
HR60_BWN-GSM_01/r01s1b28p001 61
HR60_BWN-GSM_01/r01s1b34p001 62
HR60_HNS-GSM_01/r01s1b37p001 62
HR60_HNS-GSM_01/r01s1b25p001 37
HR60_HNS-GSM_02/r01s1b25p001 37
HR60_HNS-GSM_02/r01s1b28p001 37
HR60_HNS-BRG_02/r01s1b28p001 37
================================================================================
TRAIL EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_02
================================================================================
***** MAIN ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p01 01/2/1.2
HR42_DRU-HIG_G2/r01s1b01p02 01/2/1.2
HR42_DRU-HIG_G2/r01s1b01p01 01/2/1.2
HR42_DRU-HIG_G1/r01s1b02p01 01/2/1.2
HR42_DRU-HIG_G1/r01s1b01p01 01/1/6.1
HR60_DHR-HIG_01/r01s1b31p002 01/1/6.1
HR60_DHR-HIG_01/r01s1b37p001 37/2/5.1 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b33p001 14/2/5.1 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b34p001 47/2/3.2
HR60_DEL-VSB_05/r01s1b28p001 47/2/3.2
HR60_DEL-VSB_05/r01s1b32p001 01/2/3.3
VNE_DEL-XDM_01.SL-I01/PT01 01/2/3.3
***** SPARE ROUTE *******
HR42_TTR-HIG_G1/r01s1b01p02 01/2/1.2
HR42_JNW-HIG_G1/r01s1b01p01 01/2/1.2
HR42_JNW-HIG_G1/r01s1b01p02 01/2/1.2
HR42_RWI-HSK_G1/r01s1b01p02 01/2/1.2
HR42_RWI-HSK_G1/r01s1b01p01 01/2/2.2
HR62_RWI-SDU_01/r01s1b10p05 01/2/2.2
HR62_RWI-SDU_01/r01s1b10p01 02/3/1.2
HR60_RWI-GKL_01/r01s1b35p001 02/3/1.2
HR60_RWI-GKL_01/r01s1b26p001 02/2/5.3
HR60_RWI-GSM_01/r01s1b33p001 02/2/5.3
HR60_RWI-GSM_01/r01s1b37p001 05/2/7.3 REWARI GSM M-DADRI MUX VC4S1
HR60_DDR-HIG_02/r01s1b25p001 05/2/7.3 REWARI GSM M-DADRI MUX VC4S1
HR60_DDR-HIG_02/r01s1b37p001 03/1/6.1
HR60_BWN-HLS_01/r01s1b28p001 03/1/6.1
HR60_BWN-HLS_01/r01s1b25p001 03/1/2.2
HR60_BWN-GSM_01/r01s1b28p001 03/1/2.2
HR60_BWN-GSM_01/r01s1b34p001 01/3/5.2
HR60_HNS-GSM_01/r01s1b37p001 01/3/5.2
HR60_HNS-GSM_01/r01s1b34p001 05/3/6.2
HR60_HNS-BRG_01/r01s1b25p001 05/3/6.2
HR60_HNS-BRG_01/r01s1b24p001 13/3/1.1
HR60_HNS-BRG_02/r01s1b31p001 13/3/1.1
HR60_HNS-BRG_02/r01s1b36p001 01/1/4.2
HR60_DEL-VSB_03/r01s1b33p001 01/1/4.2
HR60_DEL-VSB_03/r01s1b32p001 11/1/2.3
HR60_DEL-VSB_05/r01s1b38p001 11/1/2.3
HR60_DEL-VSB_05/r01s1b32p001 01/2/3.3
================================================================================
TRAIL VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
================================================================================
***** MAIN ROUTE *******
HR60_DHR-HIG_01/r01s1b37p001 37
DHR-HIG_01 SL-37 P-01 TOWARDS DELHI 37
NEW VNE-- 37
VNE_DEL-VSB_03.SLXX/PTYY 37
VNE_DEL-VSB_03.SLxx/PT01 35
VNE_DEL-XDM_01.SL-678/PT04 35
VNE_DEL-XDM_01.SL I/12-02 14
HR60_DEL-VSB_06/r01s1b33p001 14
================================================================================
TRAIL REWARI GSM M-DADRI MUX VC4S1
================================================================================
where I need Same data to be converted to excel file as
Below
[TABLE="width: 838"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]SR.No[/TD]
[TD]TRAIL[/TD]
[TD]
***** MAIN ROUTE *******[/TD]
[TD]***** SPARE ROUTE *******[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_01[/TD]
[TD]HR42_TTR-HIG_G1/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p02 01/1/4.3
HR42_DRU-HIG_G2/r01s1b01p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b02p01 01/1/4.3
HR42_DRU-HIG_G1/r01s1b01p01 01/1/4.3
HR60_DHR-HIG_01/r01s1b31p002 01/1/4.3
HR60_DHR-HIG_01/r01s1b37p001 37/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b33p001 14/2/5.2 VSB#14-DHARUHERA#37=PROTECTED VIA BHIWADI-90298
HR60_DEL-VSB_06/r01s1b34p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b28p001 08/2/7.3
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3
VNE_DEL-XDM_01.SL-I01/PT01 01/2/2.3 [/TD]
[TD]HR42_TTR-HIG_G1/r01s1b01p02 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p01 01/1/4.3
HR42_JNW-HIG_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p02 01/1/4.3
HR42_RWI-HSK_G1/r01s1b01p01 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p05 01/1/4.3
HR62_RWI-SDU_01/r01s1b10p01 02/1/1.3
HR60_RWI-GKL_01/r01s1b35p001 02/1/1.3
HR60_RWI-GKL_01/r01s1b26p001 13/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b28p001 37/3/6.1 GOKUL BAZAR-DADRI-BHIWANI-HANSI
HR60_HNS-BRG_02/r01s1b36p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b33p001 11/1/5.1
HR60_DEL-VSB_03/r01s1b32p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b38p001 04/3/5.2
HR60_DEL-VSB_05/r01s1b32p001 01/2/2.3[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]