Creating a new format csv file from data generated by Macro

nareshraj

New Member
Joined
Nov 9, 2016
Messages
1
Hi All, Am new in this forum. Glad to be with you.
created
I have a set of data created from a Macro. Minimised example is below:-
OLTOCABFDPOLTSLOTOLT CODESPLITTER CODEFDPCODEIP CODESEGMENT SPLITTERSEGMENT FDP
FTTH-PS-03-0/1/0F1125172.17.42.26FTTH-PS-03-0/1/00/1/0FTTH-PS-03010PS/F11/SPL13PS/F11/FDP025172.17.42.26/0/1/0SEGMENT-PS/F11/SPL13SEGMENT-PS/F11/FDP025
F1126FTTH-PS-03-0/1/00/1/0FTTH-PS-03010PS/F11/SPL14PS/F11/FDP026172.17.42.26/0/1/0SEGMENT-PS/F11/SPL14SEGMENT-PS/F11/FDP026

<colgroup><col><col span="2"><col><col><col span="2"><col span="3"><col><col><col><col><col></colgroup><tbody>
</tbody>

I want to create another excel file using those data like below to upload in an application as below format:-

##############OLT
Region NameOLT IP AddressOLT NameDevice TypeSNMP VersionRead Community NameWrite Community NamePortTimeout (s)Retransmit TimesSecurity LevelUser NameAuthentication ProtocolProprietary Protocol TypeAuthentication PasswordProprietary Protocol Password
Flic en Flac172.17.35.146FTTH-FF-02MA5600TV1publicprivate161153
##############PON14pon
OLT NameFrameSlotPortPort TypeXYZ
FTTH-FF-02010GPON
##############ONU
ONU TypeONU IDIP AddressONU NamePON PortSNMP VersionRead Community NameWrite Community NameSNMP PortTimeout (s)Retransmit TimesSecurity LevelUser NameAuthentication TypeProprietary Protocol TypeAuthentication PasswordProprietary Protocol PasswordXYZDescribeRemarkVIP
##############ODF
NamePonPortXYZ
##############SPLITTER
NameRatioPonPortLevelXYZ
FF/F08/SPL082172.17.35.146/0/1/01
FF/F00/FDP0928172.17.35.146/0/16/152
##############SEGMENT
Source NameSource TypeDestation NameDestation TypePonPortDistanceSegmnet Name
172.17.35.146/0/1/01FF/F08/SPL082172.17.35.146/0/1/0SEGMENT-FF/F08/SPL08
FF/F00/SPL462FF/F00/FDP0922172.17.35.146/0/16/15SEGMENT-FF/F00/FDP092
##############UPLINK
OLT NameFrameSlotPortPort Type


Can someone help me please.

Thanks and Regards

<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col span="2"><col span="2"><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,127,965
Messages
5,627,899
Members
416,281
Latest member
Olawunmi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top