Excel sheets name

Help Activities
, ,
1

Hi Team,

I have an extraction folder and their names contains Spot Check or calibration…etc so I need the BOT to work on the Excel that has in its name SpotCheck

2

@omar_ismail

you can use for each file in folder and in filter can give "*SpotCheck*.xlsx"

cheers

1 Like
3

Hi,

Can you try the following sample?

image
image1185×917 50.6 KB

files = System.IO.Directory.GetFiles(yourFolder)
files = files.Where(Function(f) keywords.Any(Function(s) System.IO.Path.GetFileNameWithoutExtension(f).ToLower.Contains(s.ToLower))).ToArray()

Sample20231020-1aL.zip (3.2 KB)

Regards,

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.