Load list of files in a Folder

[Josh_Good]

Hi,

I am wondering if there is a way to ‘load’ a list of files in aspecified directory/file folder?  I have an application need to monitorthe date stamps of files in folder and take action if they have been sitting there past a set threshold of time.

Thanks.

[danielrozental · Accepted solution]

Sure, look at functions filelist() and filetime().

[Josh_Good]

Thanks. Here is the code I ended up using

LOAD Distinct FileName() as FileName,

     FileTime() as filetime

FROM

[*.txt]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);