DSP RETSUBUNIT

[justdream]

Dears,

Command DSP RETSUBUNIT
is used to display RET for all sites in my network but as you know the output Text file is not well organized
and it takes time to check it one by one and put it in suitable format

Do you have Macro or any idea how to get well organized sheet in suitable format to audit all the network
using output like below Example

[justdream]

Dear,
your help is highly appreciated

[techfolkcmr]

Dears,

Command DSP RETSUBUNIT
is used to display RET for all sites in my network but as you know the output Text file is not well organized
and it takes time to check it one by one and put it in suitable format

Do you have Macro or any idea how to get well organized sheet in suitable format to audit all the network
using output like below Example

No idea with macros. But what we usually do is run command save as text file open with excel now delete MML commands, leave first column headers (delete remaining headers) and data, use text to column thats all. Though it needs manual work this is the simplest way.

[justdream]

No idea with macros. But what we usually do is run command save as text file open with excel now delete MML commands, leave first column headers (delete remaining headers) and data, use text to column thats all. Though it needs manual work this is the simplest way.

could you share with me sample input and output files
So I could understand your idea