Thanks Stephen, I'll try that -- very clever!
Bernie Lis
----- Original Message -----
From: "Stephen Markson" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, May 14, 2008 12:56 PM
Subject: [RBASE-L] - RE: Counting Number of files in a folder
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
