LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: JamesV

Hello, I am currently using the Directory List node to extract multiple files.

I would like to know if it is possible to only extract files based on the date and time they were modified?

I am trying to extract only the files that were loaded into that directory in the last 24 hours.
My report names have a date and time stamp down to the seconds.

I would prefer to be able to use the date modified field if it is an option.....if not can it be done using the file name?

eg. In the below example if both the files are in the same directory but I only want to pick up the file created after 10am, is there a way of doing this?

Name Date Modified

Report1_20150716103025.xls 16/07/2015 10:30
Report1_20150716093040.xls 16/07/2015 09:30

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mermacora

Yes, this can be done by using the results of the stat() BRAINscript function in a Filter node to process the files coming out of your Directory List node.
The stat() function returns 3 values for a given file: size, create time, last modification time. Check out the BRAINscript help for full details.

Cheers,
Mario Ermacora
Director | Lavastorm ANZ

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

And for a little self-promotion, see this example: https://infogix.zendesk.com/hc/en-us/community/posts/360050684754