topic Re: about SLS report...into excel in Operating System - OpenVMS

about SLS report...into excel

Davor_7 — Mon, 12 Sep 2005 03:59:59 GMT

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 !

Re: about SLS report...into excel

Willem Grooters — Mon, 12 Sep 2005 04:19:17 GMT

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

Re: about SLS report...into excel

Davor_7 — Mon, 12 Sep 2005 04:28:56 GMT

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)

Re: about SLS report...into excel

Ian Miller. — Mon, 12 Sep 2005 04:58:12 GMT

There is a callable interface - parhaps this could be used.