Directory;
SUB DoDir (Root)
FOR each File in filelist(Root& '\*HOSTTRNAI.TXT')
LOAD 'HOSTTRNAI.TXT' as source1,
date(date#(right(filedir(),6),'DDMMYY'),'DD MMM YYYY') as Filename2,
fields,
Where date(date#(right(filedir(),6),'DDMMYY'),'DD MMM YYYY'>='01 Mar 2012'
FROM [$(File)] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
NEXT File
FOR each Dir in dirlist (Root&'\*')
CALL DoDir(Dir)
NEXT Dir
END SUB
CALL DoDir('S:\Filepath\Mar 12')
//This takes all the files ending in HOSTTRANAI.txt, in the folder and subfolders of"Mar 12" and grabs the data from them which is then put into a table,. Each file is in a
//subfolder named
//DDMMYY as such this is a new field in the table. I would like to be able to use the line in bold to choose which files to grab, but my knowledge of the where command
i//is lacking.
Help would be appreciated.
