How to pick a specific file to work on?

Lily.L — Mon, 06 Nov 2023 22:32:00 GMT

Hi guys,

I have multiple files in the folder with the format name like this: "excel-yy-MM-dd....." , while yy-MM-dd is dynamic and will be changed day by day. How can I get the file with the current date?. For example: today is 2023-11-07. I have used the get file function but don't know what to do ... Thank you!

------------------------------
Mia Mikela
------------------------------

RE: How to pick a specific file to work on?

harish.mogulluri — Tue, 07 Nov 2023 00:31:00 GMT

Hi Mia Mikela,

You can use filter collection to filter the files based on your requirement
1) get File using Utility file - management Object
2) Create a calculate stage and add the static file name with Today date using FormatDate( Calculation stage in the screenshot out put is "FileName)
ex: "excel-"&FormatDate(Today(), "yyyy-MM-dd")
3) Create a filter statement ("Name like'"&[FileName]&"*'") -( I used out put of this calculation stage as Filtered column)
4) Use filter action in utility filter Object

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

topic How to pick a specific file to work on? in Product Forum

How to pick a specific file to work on?

RE: How to pick a specific file to work on?