Are you sure the attributes were entered properly with leading zeroes? Just about all Exchange attributes are strings, so it doesn't know or care that there are leading zeroes. Look at the mailboxes' Custom Attributes (I'm assuming that's where you have this attribute stored) and see if they're stored in Exchange with leading zeroes.
Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant Compaq Computer Corporation Protecting the world from PSTs and Bricked Backups! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Blunt, James H (Jim) Sent: Friday, February 22, 2002 3:30 PM To: Exchange Discussions Subject: RE: Directory Export Bingo! So...now I have a different question. Can I grep the file and have it spit out the records for me, where the Employee-Number field has anything other than 7 digits in it? I.E., if it has <=6 digits or 8=> digits, it pipes that record to an error file? Jim -----Original Message----- From: Kenneth Walden [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:02 PM To: Exchange Discussions Subject: RE: Directory Export Did you open the csv file with notepad _after_ you'd opened it with excel? If so, excel probably stripped (not just suppressed) the leading zeroes, so that's why they weren't there in notepad. Try re-exporting and opening with notepad first. -----Original Message----- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:54 PM To: Exchange Discussions Subject: RE: Directory Export It's not Excel doing it...I opened it in Notepad and the leading zeroes are still missing. -----Original Message----- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:50 PM To: Exchange Discussions Subject: Re: Directory Export Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. ----- Original Message ----- From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -----Original Message----- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you > using to view the data? > > ----- Original Message ----- > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled > > Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location > > data. Some people's location data is not updating. Since this field > > is required > > for this function, I exported the data to a .csv file and was > > checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers > > to 7-digit numbers, because the export is dropping the leading > > zeroes. Is there any way to force the export to export all 7 > > digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _________________________________________________________________ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin: [EMAIL PROTECTED] > > > > _________________________________________________________________ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin: [EMAIL PROTECTED] > > _________________________________________________________________ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin: [EMAIL PROTECTED] > _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED]
