You are more than welcome. I have gained far more from this list and its predecessors than I can ever hope to give back.
--- [EMAIL PROTECTED] wrote: > > Thank you Albert. This rocks! So clean, with no unwanted junk. I never > would have thought of this one. > > [EMAIL PROTECTED] wrote: ----- > > To: [email protected] (RBG7-L Mailing List) > From: Albert Berry <[EMAIL PROTECTED]> > Sent by: [email protected] > Date: 04/07/2005 12:34AM > Subject: [RBG7-L] - Re: Capturing a listing of files in a directory and > importing it into Rbase > > Try this. Then select the columns to want. > > > OUTPUT TempFile.txt > DIR *.PDF > OUTPUT SCREEN > DROP TABLE TmpImport > CREATE TEMP TABLE TmpImport ( + > ShortName TEXT (8), + > Extension TEXT (3), + > FileSize INTEGER, + > FileDate DATE, + > FileTime TEXT (8), + > LongName TEXT (256)) > > LOAD TmpImport FROM TempFile.TXT > EDIT ALL FROM TmpImport > > INSERT INTO SomePermTable + > SELECT LongName, FileDate, (FileTime + "M") + > FROM TmpImport > > RETURN > > --- [EMAIL PROTECTED] wrote: > --------------------------------- > From the does anyone have a better way department: > > I have a need to capture file names (to process in rbase) from a designated > directory. The names > will always be a static format and length, but will change (file0001.txt , > file0002.txt...). Only > files that need processing will be in the directory. My thought was to: > > output tempfile.txt > dir > output scr > > use the gateway command to import into a temporary table and use declare > cursor and (sget(.vTemp) > to capture the filenames. Is there a better way? I'm always afraid that > I've missed a function > that will do what I want very easily. Thanks for you help. > > Albert Berry > Management Consultant > RR2 - 1252 Ponderosa Drive > Sparwood BC, V0B 2G2 > Canada > (250) 425-5806 > (250) 425-7259 > (708) 575-3952 (fax) > [EMAIL PROTECTED] > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
