topic Re: Utility File Management: Get Files Patterns CSV input in Product Forum

Utility File Management: Get Files Patterns CSV input

TaronWright1 — Fri, 22 Sep 2023 14:41:09 GMT

For the Patterns CSV input, is there any way to specify something along the lines of all files except xlsx.

I want to read all files from a folder that are not excel files.

Any help would be appreciated.

Re: Utility File Management: Get Files Patterns CSV input

John__Carter — Fri, 22 Sep 2023 15:35:38 GMT

Probably best to get all files then apply a filter to the collection to exclude file type xlsx. The collection you're left with will be 'all files that are not excel'

Re: Utility File Management: Get Files Patterns CSV input

LeonardoSQueiroz — Sat, 23 Sep 2023 00:32:07 GMT

Hi Taron,

Use this action to read files from a specified folder, specify the folder path, I don't remember if there is an option to filter, if yes, use and do not need the decision stage or use and in the decision stage validate the extension.

Use a loop to cycle through the list of files retrieved from the folder.

Read the current file

"Decision" stage to decide whether to process or not based on name, use *.xlsx pattern to delete Excel files.

Regards,