[RBG7-L] - Re: Importing file names

[KarenTellef]

Tom:  If you don't care about dates and sizes, then create a simple batch file to do a "dir" with the /B parameter to skip the unnecessary stuff, launch the batch file, and load into a temp table:

OUTPUT dirtxt.bat
WRITE 'DIR C:\TEMP\*.TXT /B > C:\TEST.TXT'
WRITE 'EXIT'
OUTPUT SCREEN

SET VAR vcomspec = (ENVVAL('COMSPEC'))
ZIP &VCOMSPEC /C dirtxt.bat

DROP TABLE tmpfiles
CREATE TEMP TABLE tmpfiles (textcol50 TEXT 50)
LOAD tmpfiles FROM c:\test.txt AS ASCII


Karen

All:

I'm looking for a way to import the names of files in a folder into a
table.  These file names are, not at all, associated with R-base files.

I've tried several ways, but not successfully.

Tom Spaight