ETL and Data Integration tools - Modern ETL software for everyone

I am trying to create a process to import one (or many) files each time the process runs.

The filenames are similar to TL0401.PRN, TL0402PRN .. etc

I have tried putting in a wildcard into the filename with no success.

How is this suppose to be done ? Can there be logic to read files processed based on the date / time of the file ?

Thanks

After poking around I found the mask option, however I an still interested in knowing if there is a way to filter input file selections based on a date.

Thanks

It is all depends on what you mean by date...
Is it file creation date?
Or is date a part of file name?

you can use calculations in file names, check the documentation

Peter

Yes it would be file creation date

And what do you want to do with it?

Mike

I would like to use the file creation date as a criteria to be used to select files to be processed. ie select all files created on or after current date -1 day ..