Hi all,
I am wondering how is the best way to create a new column in fme with say last modified date and then extract the last time excel file was saved into the column for each record?
Thanks
Solved
How to add last modified date/time of Excel File and new Column in FME?
Best answer by david_r
You can use Directory and File Pathnames reader, just remember to turn on the option to retrieve file properties.
Each feature will then have an attribute path_modified_date which probably contains what you're looking for.
+15- Contributor
Maybe use a system caller?
https://www.windows-commandline.com/get-file-modified-date-time/
is of any help?
- Best Answer
You can use Directory and File Pathnames reader, just remember to turn on the option to retrieve file properties.
Each feature will then have an attribute path_modified_date which probably contains what you're looking for.
david_r wrote:
You can use Directory and File Pathnames reader, just remember to turn on the option to retrieve file properties.
Each feature will then have an attribute path_modified_date which probably contains what you're looking for.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.