Hi need help having an error { ! … } , when using a variable in a Linq query for FileInfo(). sample code below:
System.IO.Directory.GetFiles(WorkFolderPath).Where(Function(s) New FileInfo(s).Name.ToUpper.Contains(varSamples) And New FileInfo(s).Name.ToUpper.Contains(varMsg))
but if I use the live strings like:
System.IO.Directory.GetFiles(WorkFolderPath).Where(Function(s) New FileInfo(s).Name.ToUpper.Contains(“MY SAMPLE EMAIL”) And New FileInfo(s).Name.ToUpper.Contains(“.MSG”))
Create a variable to store result of this System.IO.Directory.GetFiles(WorkFolderPath)
Once you have result in this variable like lstFiles then use LINQ to filter like
lstFiles.Where(Function(s) New FileInfo(s).Name.ToUpper.Contains(“MY SAMPLE EMAIL”) And New FileInfo(s).Name.ToUpper.Contains(“.MSG”))
filteredFiles = System.IO.Directory.GetFiles(WorkFolderPath).Where(Function(s) New FileInfo(s).Name.ToUpper.Contains(varSamples.ToUpper()) AndAlso New FileInfo(s).Name.ToUpper.Contains(varMsg.ToUpper())).ToArray()
Make sure WorkFolderPath, varSamples, and varMsg are defined and assigned appropriately.