Formula tool to extract input files that are in a folder that end with yesterday date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have to extract files inside a folder that ends with yesterday's date For example folder name is "abcd_2023-02-06".
The suffix of the file needs to have yesterday's date in this format "_YYYYMMDD" and I need to extract all the files inside that folder.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@APIUserOpsGiri One way of doing this is by checking the included subdirectories option in the directory tool then filter out the directory name the file name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please find the expected output.
All the files in the directory will be read. For the use case I have created only one file to explain.
Many thanks
Shanker V
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This gets me inside the directory, but I want files inside the directory, how can I make it get the files inside it???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@APIUserOpsGiri the below filter condition will first check for the directory then the second condition will filter the file with yesterday's
//extract the directory with the name YYYY-MM-DD
Contains([Directory], DateTimeFormat(DateTimeAdd(DateTimeToday(),0,'day'),'%Y-%m-%d'))
AND
//extract the files with the name YYYYMMDD
Contains([FileName], DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,'day'),'%Y%m%d'))
date in the format YYYYMMDD format