The boss is obsessed with spreadsheets. He wants me to take data that looks
like this:

User, Joe;\\server\printer1;\\server\printer4;\\server\printer3
User, Jane;\\server\printer7;\\server\printer4;\\server\printer3
Guy, Some Other;\\server\printer1;\\server\printer4
....

and turn it into a spreadsheet, graphing user names against printer names,
and putting a Yes into each cell that indicates a printer used by a user.
Maybe getting something like this:

User, Joe;Yes;;Yes;Yes;;;;;;;
User, Jane;;;Yes;Yes;;;Yes;;;;
Guy, Some Other;Yes;;;Yes;;;;;;;
....

Any ideas on how to automate this process?

David
Stardate 4445.7

Ask in microsoft.public.scripting.vbscript

It's fairly easy to do with VBScript and Excel. I did something a few years
ago manipulating existing data and creating charts, etc. but I don't do much
Office so I'd probably have to actualy write the thing before I could offer
any direct help.

"David Trimboli" <(E-Mail Removed)> wrote in message
news:uVB3Lm%(E-Mail Removed)...
> The boss is obsessed with spreadsheets. He wants me to take data that
> looks
> like this:
>
> User, Joe;\\server\printer1;\\server\printer4;\\server\printer3
> User, Jane;\\server\printer7;\\server\printer4;\\server\printer3
> Guy, Some Other;\\server\printer1;\\server\printer4
> ...
>
> and turn it into a spreadsheet, graphing user names against printer names,
> and putting a Yes into each cell that indicates a printer used by a user.
> Maybe getting something like this:
>
> User, Joe;Yes;;Yes;Yes;;;;;;;
> User, Jane;;;Yes;Yes;;;Yes;;;;
> Guy, Some Other;Yes;;;Yes;;;;;;;
> ...
>
> Any ideas on how to automate this process?
>
> David
> Stardate 4445.7
>
>

"David Trimboli" wrote:

>The boss is obsessed with spreadsheets. He wants me to take data that looks
>like this:
>
>User, Joe;\\server\printer1;\\server\printer4;\\server\printer3
>User, Jane;\\server\printer7;\\server\printer4;\\server\printer3
>Guy, Some Other;\\server\printer1;\\server\printer4
>...
>
>and turn it into a spreadsheet, graphing user names against printer names,
>and putting a Yes into each cell that indicates a printer used by a user.
>Maybe getting something like this:
>
>User, Joe;Yes;;Yes;Yes;;;;;;;
>User, Jane;;;Yes;Yes;;;Yes;;;;
>Guy, Some Other;Yes;;;Yes;;;;;;;
>...
>
>Any ideas on how to automate this process?
>
As the format is csv. Load into excel and use vba,
I've seen some sophisticated batch files doing the necessary sorting but
without some details I won't even start.
It that always server and are the printers numbered adjacent? Up to max?

HTH
--
Greetings
Matthias________________________________________
For help on nt commands enter in a cmd window:
W2K>HH windows.chm::ntcmds.htm XP>HH ntcmds.chm