I want to export a list of groups a user is a memberof. I use a dsquery command for this. Problem is this outputs multiple lines where I'd want everything in one line, divided by a semicolon so I can import it in excel. What is the best way to do this?

Maybe using csv in this utility may help. ASAP Utilities http://www.all4you.dk/FreewareWorld... http://www.asap-utilities.com/ 18 pages of other possibles here. http://www.all4you.dk/FreewareWorld...

It probably will, but how will this get multiple lines output turned into one single line?

I dunni dsquery, but get this util: Change Then: dsquery > somefile change somefile 13,10 ";" ===================================== If at first you don't succeed, you're about average. M2

You could use Word to replace the line breaks with a comma (a comma is the standard delimiter, not the semicolon). Go to Edit<Replace. Then select the "More" button. Then at the botton expand the "Special" button. The option for your line breaks could be "Paragraph Mark", "Manual Page Break", or something else. You might have to do some trial and error to find the right one. If this is something you will be doing a lot I would suggest creating a script to automate. Michael J