Suck the file into Excel, highlight the column, then select Format -> Cells
Choose Custom, then specify the template as 0000000, Excel should put the leading zeroes back in for you. Steve Smith Common IT Services Ministry of Management Services Province of British Columbia email: [EMAIL PROTECTED] Phone: (250) 387-8698 -----Original Message----- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] 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]
