134 lines
4.6 KiB
PowerShell
134 lines
4.6 KiB
PowerShell
$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)"
|
|
}
|
|
}
|