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]
