read only the newest file from a directory

Hi @vki

You use a Directory and Path reader to read only .txt files from your directory. This reader outputs a feature for each file matching your criteria along with feature attributes such as path_filename (file name) and path_windows/paths_unix (file path), etc.

Assuming your file naming is consistent (name YYYY-MM-DD.txt), you can create a new date attribute by using the substring extractor function of the AttributeManager text editor to extract the date part of file name without the file extension (eg. 2017-12-13). Use the StringReplacer to replacer non-numeric characters (dashes in your case) and then use a Tester to verify the attribute values are numbers only. Attach a Sorter to sort by descending numeric values and use the Sampler to get the first feature which should contain the file path of the newest file. Use the path_windows attribute as the input for dataset parameter with a FeatureReader or WorkspaceRunner.

Hope this helps,

Debbi

Thanks a lot to both of you. I didn't know the Directory and Path-Reader! Now it works like a charm!

Vera

Rather than going to the trouble of parsing out the date from the filename, wouldn't it be easier to rely on the path_created_date, or path_modified_date from the Directory and Path reader? You will have to check the option to Retrieve file properties to 'Yes', but that would be an easier way to determine the latest file.

Does anyone know how to use this same or similar technique to find the latest file from a One Drive folder. I'm able to select a file from the One Drive folder, but I haven't figured out how to "search" through the list of files for the latest one. This might not be the correct approach, but if you know of one I'd greatly appreciate any insight.

Thanks,

Frank