I was able to take this output as a .csv file, then open it in excel, and use the text-to-columns feature and fixed-width rather than delimited, and then save it. It produced a comma-delimited file that accurately separated the two fields. If you can't figure out a way to create the appropriate delimiter through DSQuery, this might help...
********************** Charlie Kaiser MCSE, CCNA Systems Engineer Essex Credit / Brickwalk 510 595 5083 ********************** > -----Original Message----- > From: Steve Schofield [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 18, 2004 3:35 PM > To: [EMAIL PROTECTED] > Subject: Re: [ActiveDir] Specify Delimiter in output using DSQuery? > > dsquery * "OU=My Email > Contacts,OU=EmailOU,DC=Steve,DC=Schofield,DC=com" > -limit 40000 -attr mailNickName cn > c1.txt > > Is the syntax I'm using, apologize for not posting at first. Hard to > troubleshoot when not saying here is the error or code. > > Thanks > > Steve > > > >>> [EMAIL PROTECTED] 08/18/04 06:17PM >>> > Got to love one day requirements and deadlines, need some help > formatting an output file from DSQuery. I need to export all users > one > OU (All objects are contacts) with their CN and mailNickName > attributes > ONLY. The export file doesn't appear to have a delimiter when using > DSQuery, I'm needing to import this into SQL Server 2000. Any > utilities > that will allow to export to an txt file with a delimiter on certain > attributes from AD. HELP! > > STeve Schofield > [EMAIL PROTECTED] > List info : http://www.activedir.org/mail_list.htm > List FAQ : http://www.activedir.org/list_faq.htm > List archive: > http://www.mail-archive.com/activedir%40mail.activedir.org/ > List info : http://www.activedir.org/mail_list.htm > List FAQ : http://www.activedir.org/list_faq.htm > List archive: > http://www.mail-archive.com/activedir%40mail.activedir.org/ > List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
