[dba-Tech] file name

Thanks Bobby
I really don't have time to write that and test it out right now.  We are talking millions of files to search through.  I was hoping there was a free or shareware item existing.  
If things get tough then I may have to 
Thanks************************ Patti OConnor***********************> From: bheid at sc.rr.com> To: dba-tech at databaseadvisors.com> Date: Tue, 5 Feb 2008 17:03:13 -0500> Subject: Re: [dba-Tech] file name> > Patti,> > I do not know of any particular software, but you could write a program> using powershell, Access, or any other language to scan your file system and> use regular expressions to pick out the non-compliant file names.> > Bobby> > -----Original Message-----> From: dba-tech-bounces at databaseadvisors.com> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Patti OConnor> Sent: Tuesday, February 05, 2008 4:40 PM> To: Discussion of Hardware and Software issues; pattioc at yahoo.com> Subject: [dba-Tech] file name> > > Hi allWe are instituting a file naming convention in our office. > > Name can not start with a number. > can not have spaces > can not have special characters except for underscore _.> dates have to be yyyymmdd yyyymm > We are looking for a software package that would enable us to search through> folders and list files that do not match our new criteria. I thought I saw> something about this recently on either AccessD or here. > > I tried google but haven't devised the best search criteria keep getting up> around 500,000 or more. > Any help will be greatly appreciated.> Thanks> ************************ Patti OConnor***********************> > _______________________________________________> dba-Tech mailing list> dba-Tech at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/dba-tech> Website: http://www.databaseadvisors.com
_________________________________________________________________
Climb to the top of the charts! Play the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan