Operating System - OpenVMS
1753819 Members
8866 Online
108805 Solutions
New Discussion юеВ

about SLS report...into excel

 
SOLVED
Go to solution
Davor_7
Regular Advisor

about SLS report...into excel

hi men,
when i use $stor repo vol...,flag...
the system generates the report by pages (i have hundreds of tapes)
how can i do to disable it?
because i want to export this output into excel file. but if it(the output) displayed one page by one page, i cannot make a perfect excel file although i hide several rows.

who can help me to make a good idea?
thanks !
3 REPLIES 3
Willem Grooters
Honored Contributor
Solution

Re: about SLS report...into excel

Just a hint (assuming "$ SLS" allows you manual input, of which STORE is one)

$ DEFINE/USER SYS$OUTPUT x.x
$ SLS stor repo vol...,flag...

and than edit x.x to remove the unwanted lines.

(of course, x.x as a name is just an example)

Willem
Willem Grooters
OpenVMS Developer & System Manager
Davor_7
Regular Advisor

Re: about SLS report...into excel

yeah Willem, this is a way
but i want it to be done automatically. i donot know if EDIT function can be finished by some automatical executing file.

i found a way just now.
firstly, i "stor repo ... /output=file1.txt".
and then, i "sear "" /output=file2.txt".
thus, the file2 is more clean than file1 :)

pls reply me if you find a better way...(donot be complex,i'm a green hand)
Ian Miller.
Honored Contributor

Re: about SLS report...into excel

There is a callable interface - parhaps this could be used.
____________________
Purely Personal Opinion