Copying files with certain conditions (if)

[audra.swope]

I am attempting to copy files with certain criteria from one existing folder to another, and then eventually rename. For now, I am focusing on copying the correct files. The criteria I am hoping to use is 1) if the file name contains “WTB Alt Invest” AND, 2) if the files is a .pdf AND 3) if the file was saved out today.

I have used several activities with no success. Any suggestions?

[postwick (Paul Ostwick)]

Using DirectoryInfo.GetFiles instead of Directory.GetFiles, advanced filtering

Most times it’s recommended to use Directory.GetFiles to get the files in a folder. I’ve found DirectoryInfo.GetFiles to be more useful. It gets the files as an IEnumerable of FileInfo, which makes filtering easier and gives you more info about the files. You can later For Each through it and get any of the attributes of the file you want: filename (currentItem.Name); extension (currentItem.Extension), full path and filename (currentItem.FullName) etc. Here is the full definition of FileInfo …

[lrtetala (Lakshman Reddy)]

Hi @audra.swope

filteredFiles = Directory.GetFiles("C:\SourceFolder").Where(Function(file) file.Contains("WTB Alt Invest") AndAlso file.EndsWith(".pdf") AndAlso File.GetCreationTime(file).Date = DateTime.Today).ToList()

Regards,

[audra.swope]

Thank you all for your help. I will keep your suggestions handy for future processes. I ended up using the following flow:
For each current file in selected folder → if current files name contain “xyz” AND current file name contains “xyz”, then, copy current file full name to selected folder.