Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a situation where .xls files are auto-populating into a folder daily.
Trying to figure out how to create a LOAD for ONLY the most current file (predicated on converting the trailing epoch time). Don't want to have a human update script every day to accomplish. That will fail, and frankly I'm not up for working on the weekends!
I've seen several examples with creating different variables that are close, but not sure how to "split" the below filenames apart, convert the 13 char epoch time (which includes to the microsecond) into only "mm/dd/yyyy", then lastly load the filename where the converted epoch time stamp date = today's date.
FileName
Service_Issue_Past7days__1527242456781
Service_Issue_Past7days__1527156056113
Service_Issue_Past7days__1526983257617
Service_Issue_Past7days__1526896855137
Service_Issue_Past7days__1526637688464
Or...could this be accomplished by simply a "get the trailing number, and then only load the file with the max number?"
THANKS!
Jonathan
try this