Here's a little program I've used. It places the number of non-hidden files exclusive of sub-folders into variable vFiles:
OUTPUT Files.txt DIR C:\Windows\System32 -- substitute your folder name or variable OUTPUT SCREEN DROP TABLE FileList CREATE TEMP TABLE FileList (FileText TEXT (256)) LOAD FileList FROM Files.txt AS CSV SELECT COUNT(*) INTO vDirs FROM FileList WHERE FileText CONTAINS '<DIR>' SELECT (INT(SSUB(TRIM(FileText),-1))-.vDirs) INTO vFiles FROM FileList + WHERE FileText CONTAINS 'File(s)%bytes' DELETE Files.txt DROP TABLE FileList If you're counting files in the current directory, don't forget to subtract 1 for Files.txt. Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 512 6950 > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis > Sent: May 14, 2008 11:27 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Counting Number of files in a folder > > How can I retrieve the number of files in a given folder? > > Bernie Lis > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 14/05/2008 > 7:49 AM > No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 14/05/2008 7:49 AM
