Re: [Networker] Nsradmin
2007-08-14 13:45:19
> I have output from nsradmin and would liek to import into Excel and have it
> show up in colums....
This is not trivial. In the general case, items can be multi-valued, so
putting them into a single cell would be difficult.
> For example i have my licenses...
>
> type: NSR license;
> name: Dedicated Storage Nodes/1;
> comment: #########;
> enabler code: ####################;
> host id: ####################;
> expiration date: Authorized - No expiration date;
> auth code: ################;
>
>
> and want it to look like in Excel with information under each column.....
> typenamecommentcommenthost id
At least licensing should be pretty straightforward.
For the long answer, try
http://listserv.temple.edu/cgi-bin/wa?A2=ind0504&L=NETWORKER&P=R3545
For a quick attempt that might give you data in some cases, this might
work:
perl -ne 'chomp; s/^[^:]*:\s*//; s/;.*$//; if (/^\s*$/) { print "\n"; next; }
print "$_,"; ' <nsr_output_file>
This is a quick hack. It will *not* handle continuation lines where the
line laps over and is extended on the next with a backslash. The more
general parser will handle it.
--
Darren Dunham ddunham AT taos DOT com
Senior Technical Consultant TAOS http://www.taos.com/
Got some Dr Pepper? San Francisco, CA bay area
< This line left intentionally blank to confuse you. >
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|
|
|