Move multiple files to designated folders

[postwick (Paul Ostwick)]

Instead of For Each File with an embedded If, you could just use an expression to get all the files you want. Assign the result to a variable and then For Each through that variable, with the Move File activity inside it, using currentItem.FullName to designate the filename to move.

Create yourFilesVar as IEnumerable(of FileInfo)

Assign yourFilesVar = New System.IO.DirectoryInfo(*folderpath*).GetFiles("*0HA_280*").Where(Function(f) f.Extension.ToUpper = ".XLSX" OR f.Extension.ToUpper = ".TXT")

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 …