DSP RETSUBUNIT

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

Dear,
your help is highly appreciated

Quote:

---

Originally Posted by 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

---

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.

Quote:

---

Originally Posted by techfolkcmr

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