Data to Spreadsheet

[David Trimboli]

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

 

[Paul R. Sadowski]

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.

 

[Matthias Tacke]

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