$csv = @" TransmissionFileName TransmissionDate 1A60071O.CC1 2019-08-13 18:11:18.877 1A60161O.CE5 2019-08-13 18:14:07.467 1A60141O.C67 2019-08-13 18:05:06.860 1A60141O.C29 2019-08-13 18:01:06.810 1A60091O.C7C 2019-08-13 18:06:14.697 1A60141O.CE6 2019-08-13 18:14:06.970 1A60081O.C83 2019-08-13 18:07:05.877 1A60141O.CD6 2019-08-13 18:13:06.973 1A60301O.C59 2019-08-13 18:04:10.113 1A60231O.C3A 2019-08-13 18:02:08.957 1A60061O.CDE 2019-08-13 18:13:16.427 1A60071O.C51 2019-08-13 18:03:18.770 1A60131O.CB7 2019-08-13 18:11:02.280 1A60091O.CB2 2019-08-13 18:10:14.750 1A60231O.C49 2019-08-13 18:03:09.000 1A60151O.CC5 2019-08-13 18:12:03.230 1A60081O.C37 2019-08-13 18:02:05.783 1A60101O.C2F 2019-08-13 18:01:13.397 1A60171O.C52 2019-08-13 18:03:22.877 1A60151O.C8F 2019-08-13 18:08:03.317 1A60151O.C64 2019-08-13 18:05:03.137 1A60171O.CA5 2019-08-13 18:09:22.950 1A60071O.CCF 2019-08-13 18:12:18.890 1A60301O.C4A 2019-08-13 18:03:10.087 1A60071O.CDF 2019-08-13 18:13:18.903 1A60301O.CD8 2019-08-13 18:13:10.213 1A60231O.C2A 2019-08-13 18:01:08.943 1A60161O.C74 2019-08-13 18:06:07.350 1A60091O.C4F 2019-08-13 18:03:14.657 1A60091O.CDD 2019-08-13 18:13:14.993 1A60151O.C55 2019-08-13 18:04:03.153 1A60171O.CC2 2019-08-13 18:11:22.987 1A60151O.CD3 2019-08-13 18:13:03.230 1A60171O.C7F 2019-08-13 18:06:22.960 1A60231O.CE7 2019-08-13 18:14:09.227 1A60131O.C9A 2019-08-13 18:09:02.223 1A60231O.C68 2019-08-13 18:05:08.997 1A60301O.C2B 2019-08-13 18:01:10.060 1A60231O.CAC 2019-08-13 18:10:09.063 1A60231O.CD7 2019-08-13 18:13:09.103 1A60071O.C7E 2019-08-13 18:06:19.980 1A60151O.C82 2019-08-13 18:07:03.193 1A60151O.C9B 2019-08-13 18:09:03.177 1A60231O.C9F 2019-08-13 18:09:09.050 1A60231O.C58 2019-08-13 18:04:08.983 1A60151O.CA8 2019-08-13 18:10:03.203 1A60301O.CE8 2019-08-13 18:14:10.227 1A60091O.CA2 2019-08-13 18:09:14.737 1A60171O.C61 2019-08-13 18:04:22.903 1A60171O.CD0 2019-08-13 18:12:23.000 1A60171O.C33 2019-08-13 18:01:22.853 1A60231O.C76 2019-08-13 18:06:09.027 1A60171O.CB5 2019-08-13 18:10:22.960 1A60111O.C5A 2019-08-13 18:04:10.673 1A60211O.C53 2019-08-13 18:04:01.697 1A60111O.C78 2019-08-13 18:06:10.713 1A60161O.C66 2019-08-13 18:05:07.320 1A60301O.CAD 2019-08-13 18:10:10.173 1A60061O.C50 2019-08-13 18:03:16.277 1A60151O.CE3 2019-08-13 18:14:03.260 1A60091O.C30 2019-08-13 18:01:14.783 1A60151O.CB8 2019-08-13 18:11:03.217 1A60091O.CCD 2019-08-13 18:12:14.793 1A60171O.C43 2019-08-13 18:02:22.863 1A60151O.C36 2019-08-13 18:02:03.080 1A60141O.CAB 2019-08-13 18:10:06.920 1A60161O.C9D 2019-08-13 18:09:07.370 1A60301O.C77 2019-08-13 18:06:10.123 1A60111O.C4B 2019-08-13 18:03:10.660 1A60171O.CE0 2019-08-13 18:13:22.997 1A60131O.C63 2019-08-13 18:05:02.173 1A60141O.C75 2019-08-13 18:06:06.870 1A60171O.C6F 2019-08-13 18:05:23.663 1A60071O.C6E 2019-08-13 18:05:18.813 1A60081O.CC6 2019-08-13 18:12:05.907 1A60071O.C32 2019-08-13 18:01:18.743 1A60161O.C91 2019-08-13 18:08:07.390 1A60141O.CC8 2019-08-13 18:12:06.947 1A60161O.CD5 2019-08-13 18:13:07.423 1A60131O.CD2 2019-08-13 18:13:02.273 1A60101O.C7B 2019-08-13 18:06:13.477 1A60071O.CB4 2019-08-13 18:10:18.863 1A60081O.C9C 2019-08-13 18:09:05.870 1A60151O.C45 2019-08-13 18:03:07.227 1A60141O.C9E 2019-08-13 18:09:06.910 1A60101O.C8B 2019-08-13 18:07:15.127 1A60231O.CC9 2019-08-13 18:12:09.090 1A60231O.C93 2019-08-13 18:08:09.053 1A60141O.C92 2019-08-13 18:08:06.913 1A60151O.C72 2019-08-13 18:06:03.133 1A60301O.CA0 2019-08-13 18:09:10.177 1A60091O.C5E 2019-08-13 18:04:16.853 1A60091O.CED 2019-08-13 18:14:14.803 1A60141O.C57 2019-08-13 18:04:06.877 1A60071O.CEF 2019-08-13 18:14:18.900 1A60301O.C3B 2019-08-13 18:02:10.087 1A60071O.C60 2019-08-13 18:04:18.767 1A60091O.C88 2019-08-13 18:07:15.257 1A60071O.CA4 2019-08-13 18:09:18.850 "@ | ConvertFrom-Csv -Delimiter "`t" $files = Get-ChildItem -Recurse -File -Path '\\rejk-p-mdl001\d-drive\IFSBOData\FSV\Incoming_archi\DCP_ud\2019\08\13\','\\rejk-p-mdl002\d-drive\ifsbodata\fsv\incoming_archi\dcp_ud\2019\08\13\' | Select-Object -ExpandProperty FullName foreach($entry in $csv) { Write-Verbose -Verbose ("Looking for {0} from {1}" -f $entry.TransmissionFileName, $entry.TransmissionDate) $result = $files | where { $_ -match $entry.TransmissionFileName } } $i = 0 $result = foreach($line in $files) { Write-Progress -Activity "Line $i / $($files.Count)" -PercentComplete ($i++ / $files.Count * 100) foreach($entry in $csv) { if($line -match $entry.TransmissionFileName) { Write-Verbose "Found $($entry.TransmissionFileName) in $line" $line } } } $f1names = $f1.Name foreach($file in $f2) { if($file.Name -in $f1names) { Write-Verbose -Verbose "Ignore $($file.Name)" } }