Filter in Get Folders contents


#1

Hello.
I need to read certain Excel files that are in a folder, but the filter does not work for me. I need to know the name of the Excel files and that they contain “C1”.
The files are these:
image

I use “Get Folders contents”:


But it returns in the variable “filesc1” all files.

What should I put if I just want to know the name of the files that are xlsx and contain “C1”?
Thank you.


#2

Hi @jamo
You need to check the Name box to apply the filter.
Also, try using this regex: .*C1.*.xlsx

image


#3

Hi ashapkina.
It Works when I use:
image
but when I use:
image
not return files.
I need filter the files that contain “C1” only.


#4

Try with a dot after C1: .*C1.*.xlsx


#5

Perfect!
It works now!
Thank you very much.


#6

One question more…
Can I filter by C1 OR CCH by example?


#7

You can use | as an OR condition in regex.
You expression should look like this: .*C1.*.xlsx|.*C2.*.xlsx


#8

Perfect !!!
Thank you very much !!!